"No metrics, no progress"
Do people run a trace regularly?
Schedule jobs to look at locks, waits?
Perfmon/WMI?

with SQL 2000 hyperthreaded processors are not used correctly, and sometimes
this reduce the performance of the server.
what's appends in SQL 2005?
how to setup the processor and i/o affinity options with HT CPU?

i have a P4 server that has winserver 2003 and Directory service installed
on it.
i also enabled RRAS on this server that i use to share internet through it.
now i want to install SQL server and i want to know about the limitations

   What configuration for SQL Server 2000 do you suggest, to get the best
possible performance in SAP Business One.
Best regards,
Farenheit

I noticed on the latest TPCC numbers from November that there is NO cache on
the controllers for the database.
http://tpc.org/results/FDR/TPCC/hp_orca1tb_win64_fdr.pdf
Why is controller cache disabled for the database for a TPCC benchmark?

I would like to share with you a situation we have with one customer and ask
for opinion/advice.
The customer uses two servers where there are some custom made applications
that constantly access a SQL Server installed in another machine. We moved

We have a database were we store every day some results in a table do make
comparisons.
Since some weeks we need to reindex it every day after saving the results to
get the comparisons report in a proper time.

on the tpc.org web site (tpc-h section), we can see that the SQL Server
service starts with the -E and sometimes the -T2301
can you explain what these parameters do?
thanks

What is in my BPool?  I used to know in SQL8, but no longer know in SQL9.
What is the equivalent DMV for DBCC MEMUSAGE?

maybe you allready have read my question on the datawarehouse newsgroup.
I have some performance issues with 1 of my client's server. (SQL 2000 ent.
edition on Win 2003 ent edition, 4 Xeon 3.0ghz, 4Gb; partition of 150Gb )
The problem appear to be at the disk level.