11/02/2006

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.

Nope.

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.

Kevin3NF

No comments: