Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to check performance issue Expand / Collapse
Posted Monday, April 15, 2013 10:17 PM


Group: General Forum Members
Last Login: Tuesday, February 2, 2016 8:46 PM
Points: 188, Visits: 581
query execution is taking long time

here how to solve this

for this type of performance issues

what is the necessary steps to solve this issue

Please provide the step by step process

Post #1442571
Posted Monday, April 15, 2013 11:42 PM



Group: General Forum Members
Last Login: Today @ 10:30 AM
Points: 44,016, Visits: 41,420,-part-1/,-part-2/

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

Post #1442587
Posted Monday, April 15, 2013 11:42 PM



Group: General Forum Members
Last Login: 2 days ago @ 2:28 AM
Points: 6,809, Visits: 8,775
I would examine the execution plan as a first step.

You can export it to a .sqlplan file if you want to, and add it as an attachment to your forum request, so forum members can help out.


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution"

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1442588
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse