Viewing 15 posts - 46 through 60 (of 70 total)
Thanks Jason, appreciate all your time on this. I will indeed speak to the server admins regarding the Citrix farm....I also have the software suppliers on the case now...
October 31, 2012 at 6:17 am
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: ...
October 31, 2012 at 5:38 am
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 -...
October 31, 2012 at 4:01 am
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...
October 30, 2012 at 10:06 am
Jason-299789 (10/30/2012)
Are the boxes the same in terms of Memory, CPU's and disks?
The new server is a virtual server whereas the old one is physical. In terms of...
October 30, 2012 at 9:39 am
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...
October 30, 2012 at 9:18 am
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...
October 30, 2012 at 8:32 am
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,
...
October 30, 2012 at 7:19 am
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...
October 30, 2012 at 7:09 am
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...
October 30, 2012 at 5:30 am
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...
October 22, 2012 at 7:27 am
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...
October 22, 2012 at 6:57 am
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...
October 22, 2012 at 6:07 am
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...
October 9, 2012 at 5:41 am
Viewing 15 posts - 46 through 60 (of 70 total)