SQL 2005 Performance

Got a call on a new SQL 2005 install (RTM), with pegged CPUs. All 4 running at 100%. Task manager says we are using 1.6 GB of our 8GB RAM. Database is 1.5GB, so I figure that's pretty close.


Anyone want to guess what the final issue turned out to be after a total of 8 hours of troubleshooting by 3 different people?

Answer tomorrow...post your guess as a comment...

No winner today (i.e. no comments)....AWE option wasn't selected.


No comments: