The Multifunctioning DBA:



August 24, 2010  4:52 PM

SQL Server Performance issues

Posted by: Colin Smith
Perfomance, Tuning Advisor

I have a newly created SQL Server instance that is hosting one database that is not very large, about 10 gigs, and nothing else. The Server is configured to use 4Gigs or Memory and lock the pages in memory. The server is running SQL Server 2005 and I am seeing a large number of cxpacket waits. I...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: