Browse by Tags

• 2008
• access
• analysis
• bad
• cache
• cpu
• disks
• execution plan
• i/o
• kba
• long running
• memory
• notification
• performance
• query
• SSMS
• sys.dm
• system state
• violation
• whatsnew

• 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

• FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: An access violation may occur, and you may receive an error message, when you query Read More... Posted Wednesday, August 15, 2007 2:53 AM from SSQA.net | (Comments Off) Filed under: SQL Server, access, dmv, kba, violation, sys.dm

• 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

• Whats new with SQL 2008 July CTP - new DMVs for memory management

  As this is the 2nd instalment of public CTP of SQL Server 2008 we will be expecting more information on 'whats new' and 'whats not (deprecated)'. For me (majority of you too) having handful information with DMVs is essential, in this regad we have 5 new Read More... Posted Saturday, August 04, 2007 7:40 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, dmv, 2008, whatsnew, system state

• Why query execution timeout happens and find queries that have granted memory or waiting on memory?

  Have you ever identified the reasons for why and how does a query execution timeout happens within your SQL Server environment. For the beginners I would like to explain that b efore executing a query, SQL Server estimates how much memory it needs to Read More... Posted Monday, July 23, 2007 7:44 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, memory, dmv, notification, execution plan, bad, long running