high cnter

Question

high cnter

samsql

Hall of Fame

Points: 3044
More actions
January 23, 2009 at 5:17 am

#155167

hi m having an activity which is having a performance issue ...
i hav check the counters ..wat need to be done got confused.. wer shud i start from..
Disk Reads/sec350
Disk Writes/sec11
Split IO/Sec11
Paging File
% usage31.646
% Usage Peak28.61
Memory\\Available Bytes79646208
Memory\\Pages Input/sec0
Memory\\Pages/sec38
checkpoint pages/sec260
lazy writes/sec9
Memory Manager
Sql cache memory682
TargetServer Memory3551424
TotalServer Memory3551424
Plan Cache
Cache Hit Ratio78
SQL Statistics
Errors/sec0
SQL Statistics
Batch Requests/sec30.001

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

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

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

Why do you think you have a performance issue?

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

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 2

What activity is it? with that I mean to ask if its a query or SP or job that is taking too long all of a sudden..

Also as Gail said why do think it is a performance issue all of a sudden...

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

samsql Hall of Fame Points: 3044 More actions · Answer 3

the sp which was running was taking 1 hr rite now it is taking 7 hrs to complete...

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

Is there any blocking?

Has the volumes of data changed?

Are your indexes defragmented and your stats up to date?

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

samsql (1/23/2009)
the sp which was running was taking 1 hr rite now it is taking 7 hrs to complete...

There's a thousand things that can cause that to happen. Find out what changed and you will have your answer.

--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)

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 6

samsql (1/23/2009)
the sp which was running was taking 1 hr rite now it is taking 7 hrs to complete...

Sam - Now would be a time to work through the execution plan for that stored procedure to make sure that it has all the indexes that it needs. You might be able to pick up where one might be missing / dropped.

Additionally, without having any baseline data from which to work from it is hard to say whether your server is behaving "normally" or not as we don't know what "normal" is. Know what I mean.

So, start simple. Focus on the stored procedure getting it to perform the best you can. If you want you can save the execution plan out to a file from SSMS. Rename it with a .txt extension and attach it here so that we can look at it.

Thanks.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot