Viewing 15 posts - 46 through 60 (of 278 total)
Hi folks, thanks again for the discussion.
Well, I'm back. I don't think the extra CPU/parallelism has anything to do with it.
I've been running some tests on the test machine...
February 25, 2011 at 9:21 am
Is the deletion job trying to delete a lot of records in one go, i.e. within one transaction? If so it would be worth deleting records in smaller batches
February 25, 2011 at 3:58 am
Well, the VM was migrated, and after four days the customer came back to say performance had improved.
The metrics I pulled out after the migration also supported this. There's still...
February 24, 2011 at 1:03 pm
Oh, absolutely. Well, so long as I manage to get to the bottom of the issue!
February 24, 2011 at 12:58 pm
Jim Murphy (SQLWatchmen.com) (2/24/2011)
Ha! Another fun day in the sun.
I deal with a lot of 3rd party apps, so I have plenty of those!
Doesn't sound like a CPU issue...
February 24, 2011 at 12:41 pm
Thank you both for your responses.
As far as I knew CXPACKET waits were specifically parallelism related, good to know I haven't been wrong all along.
I've left the office now so...
February 24, 2011 at 12:13 pm
1) They are cummulative, and applying CU4 would get you 1,2 and 3 included
February 24, 2011 at 10:26 am
DobermannCanis (2/23/2011)
February 23, 2011 at 10:52 am
DobermannCanis (2/23/2011)
So, when using log shipping, as the log updates the data base, users are kicked out?
yes, because the database is in a Restoring state while the logs are being...
February 23, 2011 at 10:48 am
Have a look at the blog post here:
http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html
You need to see what the underlying cause of growth is by setting up monitoring.
Of course, depending on the size...
February 23, 2011 at 10:29 am
Your SQL Server 2005 is at SP3 according to the long version numer
See the link below, it lists all version numbers:
February 23, 2011 at 10:23 am
From the sounds of the OP, I think it would be worth looking into Visual Studio for deploying databases/database changes. Of course Visual Studio is not free...
February 22, 2011 at 5:19 am
GSquared (2/21/2011)
One solution I saw someone write about recently was mirroring, and keeping a snapshot on the mirror which could then be used for running reports. I'm not sure...
February 22, 2011 at 4:05 am
Thank you both for your input
The VM is being migrated to another disk tonight. Strangely, that SQL Server was only sharing a disk with one other machine, a dev box...
February 18, 2011 at 12:13 pm
Viewing 15 posts - 46 through 60 (of 278 total)