SQL Server 2005 has totally replaced DTS with SSIS. I suggest grabbing a couple "learn in 24 hours" books or go grab Brian Knight's wonderbook of SSIS god power.

I bet you can run SQLIOSIM on that host and get what you're looking for...

I'd still check the connection strings. Each server probably makes a single connection to the database so chances are the connection strings are different on the two servers.

Had the...

Are you doing a rebuild of the indexes or a re-org? Are autostats turned on or off for the database?

As long as the business tier can maintain the data integrity, the performance impact is only limited to the speed of that layer. Usually the database layer is optimized...

Not quite sure I follow the question exactly. What are the business requirements?

This looks like it may be using the PIVOT operator but not sure.

Timeout errors are generated at the provider / application layer and not by the SQL Server. Check the connection string of the client application to make sure it has...

By the way, to address the original problem... time out errors are generated at the application / provider level, not by the SQL Server. Chances are the connection string...

Out of date statistics can also lend to increased CPU usage.

When was the last time you rebuilt your indexes or updated statistics on these tables?

Run a profiler trace and capture the duration for all sql statements. That's your best bet. Then select those statements with the highest duration and tune from there.

Personally I like Idera's tool because it doesn't require me to deploy some silly agent across all my SQL Server environments.

Just curious, not criticizing at all but...

Wouldn't a question like this be best suited for the administration forum?

I'm seeing a lot of these types of questions being posted in the...

Actually when you changed the fill factor of the index, you effectively rebuilt it. The reason why you're seeing a higher pages scanned count is simply a factor that...

It all has to do with the cached query plan and how SQL Server determines whether it can reuse the plan or generate (recompile) a new one. Sometimes SQL...

Daignostic Manager is a fantastic tool. Granted you can probably spend months creating something yourself but why? Agentless based, low impact and footprint, smart monitoring, KLMs pre-configured and...