Browse by Tags

• analysis
• cache
• database
• disk space
• disks
• dmv
• i/o
• kba
• memory
• performance
• shrink
• SQL Server
• SSMS
• timing

• sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

  The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any Read More... Posted Friday, August 17, 2007 11:04 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, SSMS, memory, cpu, dmv, analysis, disks

• SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications SQL Server timing values may be incorrect when you use utilities or technologies that Read More... Posted Friday, August 17, 2007 6:45 PM from SSQA.net | (Comments Off) Filed under: SQL Server, cpu, kba, timing

• List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

  Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within Read More... Posted Monday, August 06, 2007 5:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, cache, cpu, dmv, i/o

• Does DBCC SHRINKFILE consumes operating system resources such as memory, CPU usage etc.?

  Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to the server. But think about performing the SHRINK operation of transaction log & database files on regular basis, say within a scheduled job or ongoing Read More... Posted Wednesday, July 25, 2007 7:30 PM from SSQA.net | (Comments Off) Filed under: SQL Server, database, memory, cpu, shrink, disk space