Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Tuning Advisor

1
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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1