I added those counters in to my usual perfmon collector set and ran the query again....here are the average values:

Physical Disk: Avg Disk sec/Read: ...

Morning all...

In general large sorts run ok on the server - I just ran a select statement sorted by 3 columns which returned ~800,000 rows in about 20 seconds -...

Jason-299789 (10/30/2012)

I take it that the SQL server is a 64bit box and doesnt have any throttling going on in terms of Max Degree of Parallelism, max memory usage.

How...

The new server is a virtual server whereas the old one is physical. In terms of...

Indeed I have...it's a bit of a mystery at the moment, the sort is just killing the CPU. I have also checked the indexes are set up the same...

Just a bit more info for you....

The database was being transferred from a SQL 2005 server to a SQL 2008 R2 server. I have now determined, after trying it...

Here is the code from the view itself....Thanks!

SELECT TOP (100000) ei.Cash, ei.CashU, ei.Condemn * - 1 AS Condemn, ei.DocumentNo, ei.EstCode, ei.Functions, ei.FunctionsU, ei.GPYear, ei.GPPeriod, ei.HoursStd,

...

Hi Artoo,

Here are the results of using the SHOWPLAN_TEXT command on both servers....hopefully this gives you what you want? Apologies for the long post....and also the smiley faces in...

There shouldn't be an issue with index fragmentation or data volumes etc., as this is a direct copy of a database from our production environment, where it runs a lot...

Lowell (10/22/2012)

matt.gyton (10/22/2012)

These are just standard SQL Agent Jobs being run on a schedule, so I'm assuming I could just change the default language setting for the login they...

Hi Lowell,

These are just standard SQL Agent Jobs being run on a schedule, so I'm assuming I could just change the default language setting for the login they are being...

Thanks Dugi - that looks good!

Currently the jobs just run under the domain account that runs the SQL Agent Services, although this account is not listed under the Logins in...

That looks good - many thanks!

Hi Perry,

Thanks for that - basically, we have a DR site and our Server Admins have configured WANSync to do regular, block-level copies of all the MDF and LDF files...

Just in case anyone is interested I managed to resolve this issue....

I simply added the account running SQL Agent to the local admin group on the server, then restarted the...