Begining a tuning | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Begining a tuning

Where should I look first?
The hardware or the SQL server software. thanks! My configuration:
– SQL 2K Server Standard + SP3a
– Win 2K Server Standard + SP4
First try to tuning software, if after do all work you still have low performance may be is time to think in hardware. BTW: Kindly don’t duplicate post is hard to follow. I will delete the other one.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
First, begin by taking a look at this website, especially this article series: In most cases, about 80% of performance issues lay with application software, and 20% or so with hardware and the SQL Server configuraton. —————————–
Brad M. McGehee, MVP
Mainly go thru all the tips category in this website which gives you optimum information about Tuning, where no other site have this much information. _________
Satya SKJ

Deleted the spam on the previous post. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.