November 4, 2013 at 11:10 pm
Hi
Can anyone guide regarding how to do performance tuinning using SQl 2012 Express edition
Regards
November 4, 2013 at 11:36 pm
Pretty much the same way you do it in any other edition of SQL. There's nothing special about Express in that sense.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 4, 2013 at 11:43 pm
Correct me if i am wrong Profiler not available in express.
How to start the trace in 2012 express edition?
Tried to search on net but could not find. Can you provide some link from where i can read and check.
November 4, 2013 at 11:49 pm
Use the server-side trace procedures (sp_trace_create and related). They're there even if profiler isn't. Or use extended events.
You can use profiler from any other edition to create the trace script. Or search google, there should be lots of available tracing scripts lying around.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 5, 2013 at 12:27 am
Thanks for you reply. Could you be able to give me steps to capture following info using sp_trace_setevent
1. want to capture quueries being executed
2. Date and time on which it was executes
3. user executing the query
November 5, 2013 at 1:22 am
If you have an instance that does have profiler, use the GUI to create the trace you want, then export the trace creation script. I don't know anyone who writes these scripts by hand.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 5, 2013 at 2:38 am
Thanks a lot. It works.
November 5, 2013 at 4:10 am
One more query I could export and work with the trace. I capturing "Showplan All' event. How do I convert the textdata of this to graphical plan?
November 5, 2013 at 4:13 am
got it. I saved the text as .sqlplan file and then opend it. It shows graphicl plan.
November 5, 2013 at 5:05 am
I thought there was a way to install the tools for SQL Express... but maybe said tools don't include Profiler.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 6, 2013 at 1:40 am
TheSQLGuru (11/5/2013)
I thought there was a way to install the tools for SQL Express... but maybe said tools don't include Profiler.
They don't--see the entry for SQL profiler here:
http://msdn.microsoft.com/en-us/library/cc645993.aspx
There are third-party profiler tools that work with Express edition, but the one I use was discontinued some time ago and I haven't done any research into finding another one.
November 7, 2013 at 2:29 am
You might also want to look at the Plan Cache, I am sure the express version allows you to make use of the Dynamic Management Views and Functions.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply