I am working on a performance issue on SQL Server 2005 Ent. SP1 x64-bit
cluster.
I am lack of available tools I used on 2000. How do you handle performance
issues on 2005 64-bit?

I'm suffering a strange issue in SQL 2005, and I have the same with SQL
2000.
I'm executing my DTS or SSIS loading. Everything is ok, performance in good.
My packages are optimized to load 1 year at a time.

We have a customer site where they do thousands of Updates/Inserts a day.
They are experiencing performace problems. We had been including Shrink
Database by mistake in the nightly Maintenance Plan. I say by mistake,
because I just read an article on Tibor Karaszi's site which ...

49% of my time is waiting on wait stat MISCELLANEOUS, what is this?  BOL
does not list this one.
24.8% is waiting on SQLTRACE_BUFFER_FLUSH
24.7 is waiting on DBMIRRORING_CMD

Friends,
I have one new problem with sp_executesql.I heve one Server with SQL Server
2000 Enterprise, with SP3a.
One web aplication has a xml componet that work in IIs 5.0 (framework 1.1).

In our application we have a table that contains hundreds of millions of rows
that has to be updated frequently, it actually has to be “upserted” – updated
so some values are inserted and some are updated.
The fastest way of doing this is via a temporary table into which we load

Our company imported the entire library of congress bibliographic and
authority records (database stands at 140GB).
When doing this select:
   select