Browse by Tags

• 2000
• 2005
• 64 bit
• awe
• buffers
• cpu
• databases
• memory
• monitoring
• paging out
• performance
• server
• sql server
• verison
• worker threads

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
07 March 08 03:54 AM | SQL Master | 2 Comments   

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently Read More...

Filed under: performance, sql server, dmv, memory, windows, awe, monitoring, worker threads, 2005, 2000, paging out, 64 bit, verison, buffers

Using DMVs is it possible to identify whether CPU is hyper-threaded?
29 May 07 06:12 AM | SQL Master | (Comments Off)   

SYS.dm_os_sys_info DMV delivers most important information such as Operating System CPU tick count, hyperthread ratio, physical and virtual memory, as well as the worker and scheduler counts. From the derived values of this DMV if you observe hyperthread_ratio Read More...

Filed under: server, dmv, databases, windows, cpu