I’m a huge fan of RML utilities for SQL DB Engine workload analysis. Its a fantastic tool fro being able to capture a trace and point a finger at offending users, applications, batches, queries and even see plans and resource usage. You can download RML from this link http://www.microsoft.com/en-us/download/details.aspx?id=4511 One issue is that the Report … Continue reading Getting RML to work on Windows 8.1
Tag: Performance
There are lots of good blogs on how to optimise the performance of a tabular model by looking at where space is going to. The alternative approach we will discuss here is to look at the trace file to determine where time has been spent on processing. This approach is very valuable for the MOLAP … Continue reading Baselining Tabular Model Processing with a trace file