SQL Server Aggregator : dmv

SSAS 2008 - small DMV improvement

Darren Gosbell [MVP] - Random Procrastination — Thu, 21 Feb 2008 22:21:53 GMT

I was just checking the DMVs in SSAS 2008 CTP6 to see if they had changed between CPT5 & 6. Particularly in regard to the list of limitations that Vidas posted . As far as I can tell the only thing that appears to have changed is that "SELECT DISTINCT"...(read more)

Building a better DMV

Darren Gosbell [MVP] - Random Procrastination — Wed, 30 Jan 2008 11:45:18 GMT

Following along on my recent theme of exploring the metadata rowsets and the new Dynamic Management Views (DMV) in SSAS 2008. I have added a new DMV function to the Analysis Services Stored Procedure project ( www.codeplex.com/ASStoredProcedures ) which...(read more)

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

SSQA.net — Fri, 17 Aug 2007 13:04:00 GMT

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)

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

SSQA.net — Tue, 14 Aug 2007 16:53:00 GMT

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)

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

SSQA.net — Sun, 05 Aug 2007 19:32:00 GMT

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)

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

SSQA.net — Sat, 04 Aug 2007 09:40:00 GMT

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)

List the wait resources and scheduler waits from OS

SSQA.net — Tue, 24 Jul 2007 11:01:00 GMT

Got the below script from PSS when we were dealing with a support case to identify the root cause for Scheduler errors during a performance loss & exception errors exercise: select scheduler_id, current_tasks_count, runnable_tasks_count, current_workers_count,...(read more)

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

SSQA.net — Mon, 23 Jul 2007 10:39:00 GMT

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...(read more)

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

SSQA.net — Mon, 23 Jul 2007 09:44:00 GMT

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)