Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks" - Bart Duncan... - 1 views
-
Sergey Leifer on 11 Jul 11Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"
MS SQL Server, Analysis Services, Integration Services useful links and code samples
set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...
set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...
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...