Browse by Tags

SSAS 2005 – Server side tracing starter kit
07 April 2008 22:32

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done! It did take a while to piece together how to do it though... Read More...

by ACALVETT | 1 comment(s)

Filed under: Tools, Tips, Performance, SSAS 2005, Analysis Services

What is that SPID doing?
27 March 2006 17:44

This is certainly not a new topic but something that i felt was worth revisiting and reminding people about, especially because i find many people are not aware of the ability to extract the statement within a stored procedure being executed. So, prior to SQL 2000 SP3, when we want to know what code a SPID is executing we have to use DBCC INPUTBUFFER (). The... Read More...

by ACALVETT | with no comments

Filed under: SQL 2000, Tools, Tips

2005 - Alter failed for server XXX
13 February 2006 18:04

Thats exactly what i thought!! What the hell does that mean? Well, for me this occured in the context of running the maintenance plan integrity check task. It had been running fine for weeks but suddenly boom every time it ran it would fail with "Alter failed for server XXX". There was no obvious reason for this error so i had to dig out profiler to see what... Read More...

by ACALVETT | with no comments

Filed under: Maintenance Plans, SQL 2005, Tools, Tips