Express edition Performance tunning

Question

Express edition Performance tunning

Krishna1

Hall of Fame

Points: 3666
More actions
November 4, 2013 at 11:10 pm

#282073

Hi
Can anyone guide regarding how to do performance tuinning using SQl 2012 Express edition
Regards

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krishna1 Hall of Fame Points: 3666 More actions · Answer 2

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.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krishna1 Hall of Fame Points: 3666 More actions · Answer 4

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krishna1 Hall of Fame Points: 3666 More actions · Answer 6

Krishna1

Hall of Fame

Points: 3666

November 5, 2013 at 2:38 am

#1664070

Thanks a lot. It works.

Krishna1 Hall of Fame Points: 3666 More actions · Answer 7

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?

Krishna1 Hall of Fame Points: 3666 More actions · Answer 8

got it. I saved the text as .sqlplan file and then opend it. It shows graphicl plan.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 9

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

paul.knibbs SSCoach Points: 15320 More actions · Answer 10

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.

Bruceo SSCrazy Points: 2152 More actions · Answer 11

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.