Optimizing Server Config & DB Config etc

Question

Post reply

Optimizing Server Config & DB Config etc

Pete-L

Ten Centuries

Points: 1280
More actions
September 28, 2010 at 2:19 am

#228842

Hello,
I've recently been looking at how we can improve our current environments from a server config point of view and a db design side of things.
As I didn't design the databases and the design docs are non existent is there any way I can see what are commonly used queries are so that covering index can be setup rather than the current lack of index altogether.
Also if I was building a new server to prove that doing xyz tweaks improves performance is there any better tool to use than SQLIO?
Thanks,
Peter

Viewing 4 posts - 1 through 3 (of 3 total)

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

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

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

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-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

Pete-L Ten Centuries Points: 1280 More actions · Answer 2

Pete-L

Ten Centuries

Points: 1280

September 28, 2010 at 8:19 am

#1228390

Excellent thanks thats just what I was after! 🙂

Enterprise DBA SSC-Addicted Points: 478 More actions · Answer 3

SQLIO is great tool for testing server perfomance prior to installing SQL, it produces latency and throughput numbers that can be compared before and after your server level tweaks. You may want to gather IO stats of your current system before building the new to assist in determining disk and file layout.

Dan