Re: Context Switches Greater 10,000
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 05/14/04
- Next message: Ashish Ruparel [MSFT]: "RE: multiple instances of sql - 2 Gb memory limitation?"
- Previous message: Peter: "SQL Server Backup"
- In reply to: Mike: "Context Switches Greater 10,000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 23:28:16 -0400
That's most likely not the answer. You need to determine why you get rates
such as those. It's quite possible you have other issues that youcan address
to cut this down. See if these help:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
-- Andrew J. Kelly SQL MVP "Mike" <anonymous@discussions.microsoft.com> wrote in message news:cd0301c43943$9824b0f0$a101280a@phx.gbl... > > 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: Ashish Ruparel [MSFT]: "RE: multiple instances of sql - 2 Gb memory limitation?"
- Previous message: Peter: "SQL Server Backup"
- In reply to: Mike: "Context Switches Greater 10,000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
