So you’ve got a BI solution up and running and want to find out what MDX queries are actually running on your server?
Well this guide will help you quickly find out.
Step 1: – Launch SQL Profiler – You can find it on the Tools menu of SQL Server Management Studio (SSMS):
Step 2: – Login to Analysis Services:
Step 3: – Start a new Trace:
Step 4: – Remove a lot of the noise by removing all the events you don’t care about:
Just leave the ‘Query End’ event ticked.
If your server isn’t very busy then you can probably just click ‘Run’ to start profiling, otherwise continue onto the next step.
Step 5: – Filter the traces even more
Before clicking ‘Run’ you can do some more filters by clicking on the ‘Column Filters’ button.
Step 6: – Show queries for only a specific user
Here I’m adding a filter to only show results where the NTUserName = grudman ( grudman is my username)
Step 7 – Click run, and watch the trace logs come in 🙂
Step 8 – Optionally create a template for all this
Please see my next article for the steps you’ll need to perform
As always all feedback is welcome 🙂
I was googling myself as part of an SEO exercise and came across a feature request I made a couple of years ago.
It’s good to see that Microsoft do actually listen to their customers.
As you probably already know; the values in an Identity column are auto-generated by the database, and as such you can’t just insert a specific value into those columns.
Normally if you try to insert a specific values into an Identity column you will get an error similar to this:
Well sometimes you really do want to use specific values for the Id. For example you may want to pre-populate a database or you need to fix some data, or a hundred other reasons. Well this is how you do it:
SET IDENTITY_INSERT [dbo].[Customer] ON -- This turns auto-generated values off
INSERT INTO [dbo].[Customer] (Id, [Name]) VALUES (123, 'Gordon') --Insert your rows
SET IDENTITY_INSERT [dbo].[Customer] OFF -- This turns auto-generated values back on
Well I hope this helps someone out there! 🙂
All questions and feedback are welcome.