We have context switches/sec around 18000 on an 8 way CPU . I am using SQL
2000. Is that good or bad ?
If bad, what can i do further to investigate or reduce it
ThanksIt's not horrible but could probably be better. I would check to see how
your disk queues and cache hit ratios are.
--
Andrew J. Kelly
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:On1JTJjVDHA.2096@.TK2MSFTNGP11.phx.gbl...
> We have context switches/sec around 18000 on an 8 way CPU . I am using SQL
> 2000. Is that good or bad ?
> If bad, what can i do further to investigate or reduce it
> Thanks
>
No comments:
Post a Comment