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.