Context Switches Greater 10,000
From: Mike (anonymous_at_discussions.microsoft.com)
Date: 05/13/04
- Next message: Denny: "Longest SQL runtime??"
- Previous message: Jake: "what access level is needed to view diagrams?"
- Next in thread: Andrew J. Kelly: "Re: Context Switches Greater 10,000"
- Reply: Andrew J. Kelly: "Re: Context Switches Greater 10,000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 16:39:55 -0700
I have a server that has SQL Server 2000 Enterprise
Edition with SP3A and Windows 2000 Advanced Server as the
operating system.
This is a new system and I checked my context switches
they average 9600 Context Switches /sec over the was 3
weeks. During the busy part of the day they average
14,000 Context Switches / sec.
Should I enable the fiber-based schedule in SQL Server by
setting the lightweight pooling configuration option to 1?
Please help me with this task.
Thanks,
Mike
- Next message: Denny: "Longest SQL runtime??"
- Previous message: Jake: "what access level is needed to view diagrams?"
- Next in thread: Andrew J. Kelly: "Re: Context Switches Greater 10,000"
- Reply: Andrew J. Kelly: "Re: Context Switches Greater 10,000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
