Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SQL Server for multiprocessor

Author  Topic 

SinghManish
Starting Member

1 Post

Posted - 2009-01-09 : 05:57:27
Hi Everyone,

My SQL Server is installed on multiprocessor system. So, I want to know effect of multiprocessor on following.

@@max_connections
@@timeticks
@@io_busy
@@idle
@@cpu_busy
@@connections
@@pack_sent
@@pack_received
@@packet_errors
@@total_read

As per my observation @@io_busy, @@idle varies according to processors(depend on number of processor). Also @@timeticks is independent of the processors.

I am not able to get effect for other and how does multiprocessor effect (means in which proportion values get change).

Could you please suggest something on this?

Thanks in advance.

-Manish
   

- Advertisement -