Slow performance

Question

Slow performance

Viewing 6 posts - 16 through 20 (of 20 total)

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

Nirav_Joshi SSC-Addicted Points: 491 More actions · Answer 1

Hi,

You can perf dash board to find what is going on your SQL Server when you will find that there is CPU or Memory spike is there

Please find link to download it

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Regards,

Nirav

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Thanks Gail for prividing the links. Much useful.

However, can you please let me know -

--whether any standard metrics (predefined std value) is available to judge the perfmon counter values to understand whether the values are large or small?

Thanks.

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 3

GilaMonster (9/1/2009)
I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.

My favourite is the over eager virus scanner.

Clear Sky SQL
My Blog[/url]

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 4

Dave Ballantyne (9/3/2009)
GilaMonster (9/1/2009)
I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.
My favourite is the over eager virus scanner.

Im with Dave on this... Make sure you exclude mdf, ldf, ndf... Also I exclude .bak and .trn

Silverfox SSC-Insane Points: 23150 More actions · Answer 5

Check to see if you have any scheduled jobs running at the time as well.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

sql_lock (9/3/2009)
Dave Ballantyne (9/3/2009)
GilaMonster (9/1/2009)
I've seen a SQL Server brought to its knees by an admin copying a large backup file off the server.
My favourite is the over eager virus scanner.
Im with Dave on this... Make sure you exclude mdf, ldf, ndf... Also I exclude .bak and .trn

Don't forget errorlog.* and .trc.

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