How to start Perf improvement

Question

How to start Perf improvement

ramana3327

SSCoach

Points: 19722
More actions
June 18, 2014 at 5:52 pm

#287670

Hi,
I joined recently in a company (Need to improve the Performance).
That application is related to the some shopping cart system (Kind of Amazon). Customers can sign in and select items and save it.
I need to improve the performance of some sps or database side problem. Because I don't have access to remote desktop. Then how can I see the memory & CPU related issues. I mean how can I run the counters without connecting to the remote desktop. How to start identifying the problems.

Viewing 6 posts - 1 through 5 (of 5 total)

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

I am just wondering how you got hired by a company that is having performance problems with a SQL Server application, to help them fix said performance problems, when you don't actually know how to DO performance tuning of SQL Server applications.

Here's one recommendation though: you probably should not use statement level completed profiler events. They can REALLY hit the system hard, especially with lots of ad-hoc stuff or cursors or UDFs in play.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

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

I'm pretty sure I've linked these before:

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Is this the 2005 server?

If it's critically important and must be done now, the best thing you can probably do is get someone in to tune the DB and teach the current staff how to tune. Tell management that the fastest way for you to learn would be from someone experienced, and get someone in. Struggling for a month trying random stuff is not the way to go.

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

ramana3327 SSCoach Points: 19722 More actions · Answer 3

Hi Kevin,

Mostly I work in the dev or testing box only. So it is ok to run the profiler

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 4

ramana3327 (6/19/2014)
Hi Kevin,
Mostly I work in the dev or testing box only. So it is ok to run the profiler

Considering all of the performance related questions you've been asking lately, I have to admit that I wonder the same thing as Kevin.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ramana3327 SSCoach Points: 19722 More actions · Answer 5

Sorry here my opinion is I have to work mainly in Dev & Test box only. So I am taking the statement completed in the profiler.