I have set up performance counters and collected data in spreadsheet. Based
upon what calculation i can set the baseline from the collected data.(MAX OR
AVG)
Eg:- Processor Time and other counters

We have recently upgraded our system from SQL2000 to SQL2005. After this we
rebuild all indexes and run the update statistics procedure.
We have some stored procedures and 2 of them was performing really bad after
the upgrade. They both contains subqueries in the where-clause and ...

Hi everyone,
I just did an ALTER TABLE to add 3 new columns (2 with values, 1 allowing
NULL) on a table containing 110 millions rows and since I had very different
performance timings on two almost similar servers (14x slower), I'm wondering

considering further normalization on my database model, I'd like to do
some persomance tests on a SQL Server 2000 DB including the data of an
test system.
For the performance runtime measurement, I thought about making

I have SQL Server 2000 (SP3) running on Windows 2003 Server Enterprise with
16GB memory. Problem is that SQL Server does not use memory more than 2GB.
I've heard /3GB and /PAE switches and even tried /PAE switch but with no
luck.

I have heard conflicting information. Does anyone here know whether the SAS
10k drives perform as quickly as the standard SCSI drives.  I am looking to
expand my server with a Serial Attached array.  The 1U size of the SAS array
is nice but it only comes with 10k SAS drives.