Skip to main content

Home/ MS SQL Server and Analysis Services/ Group items tagged Monitoring

Rss Feed Group items tagged

Sergey Leifer

A closer look at CXPACKET wait type in SQL Server - 0 views

  •  
    If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits...
Sergey Leifer

SQLDiag for SQL Server 2005 - 0 views

  •  
    This article explains how to use SQLDiag as a Service to get more thorough diagnostics than the standard Profiler traces or Server Side Tracing...
Sergey Leifer

T-SQL: disk free space alert - 0 views

SQL Server T-SQL Monitoring Management

started by Sergey Leifer on 29 Aug 10 no follow-up yet
Sergey Leifer

SSAS performance counters - 0 views

SQL Server Analysis Services Monitoring

started by Sergey Leifer on 29 Aug 10 no follow-up yet
Sergey Leifer

SSAS performance counters - 0 views

SSAS performance counters * Direct hit ratio - Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. Higher is better. * Evictions / sec - Rate of evictio...

SQL Server Analysis Services Monitoring

started by Sergey Leifer on 02 Sep 10 no follow-up yet
Sergey Leifer

Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks" - Bart Duncan... - 1 views

  •  
    Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"
1 - 9 of 9
Showing 20 items per page