what is the best way?

Question

Post reply

what is the best way?

Nelson Viggiani-257464

Grasshopper

Points: 17
More actions
September 2, 2005 at 8:13 am

#165372

I just start on a new company with 10 SQL Servers and they're asking me to do a
performance on all servers.
what's the best way to do that?
thanks

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

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Not really about perf tuning but a good start for you :

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

Also you can check the articles section here, there's a whole section about tuning.

Nelson Viggiani-257464 Grasshopper Points: 17 More actions · Answer 2

ok thanks but , wich procedure I can run to tunning the databases?

thanks

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

There's no magic button for that, you need to learn it by yourself : Perf tuning articles

Clive Strong SSChampion Points: 11222 More actions · Answer 4

Agree with rqR'us.

There is no one procedure to analyse the database/server performance.

There are many area's which you would need to investigate. Your question is a bit too open. I would suggest reading through the links provided and them coming back with questions on specific areas of server or query tuning.

Clive

johansmax SSC Rookie Points: 28 More actions · Answer 5

This is just a comment. The first thing to do is reading your company service level agreement. This agreement should contains lower limit to acceptable perfomance. If the system already beyond this limit than no performance tunning should be done.