Browse by Tags

All Tags » Performance (RSS)
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: , , , ,
SQL 2005: Procedure cache cleared
05 June 2006 18:15
I don't normally write about a technet article but i must say that 917828 caught my eye and i felt that it was worth highlighting it. The reason it caught my eye is that it describes a number of scenarios where by the whole procedure cache is flushed which will clearly lead to a decrease in query performance whilst the cache builds up again. The most alarming... Read More...
by ACALVETT | with no comments
Filed under: , ,
A performance analysis example
15 January 2006 17:53
Last week i was dragged kicking and screaming away from my allocated SQL 2005 days to spend 2 days diagnosing performance problems on one of the firms Systems and write a report. Due to the sensitive nature of the data on the system it has been managed by another team and this was the first time i had looked at it. I thought i'd share my thought process to identifying... Read More...
by ACALVETT | with no comments
Filed under: , ,