Viewing 15 posts - 13,561 through 13,575 (of 22,213 total)
Lee Forst (1/18/2011)
January 18, 2011 at 8:10 am
The thing is, your process is causing the blocking. I'd seek a solution by address the process. I think you're in a "Doctor, doctor, it hurts when I do this"...
January 18, 2011 at 8:07 am
I'd refer to Itzik's book as well.
But, while you're waiting for it to arrive, there is some explanation here. Here's a bit more. None of this addresses it directly...
January 18, 2011 at 7:57 am
Yeah, without a, pick your time period, 6 months/year/decade worth of transaction monitoring, there is no way to know what data was accessed.
If you're interested in what has been access...
January 18, 2011 at 7:46 am
Unless I'm reading this wrong, 20gb is very small as databases go. I agree that seperating out the storage to different filegroups would allow you to break up the backup...
January 18, 2011 at 7:39 am
So if I understand the process, you've got a query that inserts into Table A (prosumably selecting from other sources), selects from that table using some kind of aggregate query,...
January 18, 2011 at 7:34 am
GilaMonster (1/17/2011)
January 17, 2011 at 4:05 pm
Kwisatz78 (1/17/2011)
Hi I am in a similar situation to you in that I am just getting into performance tuning. I have found this a great article:http://sqlcat.com/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx
That is an excellent...
January 17, 2011 at 4:04 pm
dajonx (1/17/2011)
January 17, 2011 at 4:02 pm
I'd suggest spending time over at Paul Randal's blog. Here's a link to articles on cache over there.
January 17, 2011 at 3:30 pm
Try this. Instead of the COUNT statement, use an EXISTS statement. It will perform much better.
IF EXISTS (SELECT * from dbo.tbl_WhateverItWas WHERE Val1 = @Param1 AND Val2 = @Param2)...
Of course,...
January 17, 2011 at 3:27 pm
Roy Ernest (1/17/2011)
Lots of people have talked very Ernestly to me regarding being Ernest all the time in everything I do... 😀
It is important to be Ernest.
January 17, 2011 at 1:14 pm
Why do you think it's not related to management studio? The queries are retrieiving the amount of space available. Couldn't someone be running one of the standard reports from SSMS...
January 17, 2011 at 12:53 pm
Yes and yes.
When you alter a stored procedure, the plan in cache, if there is one, is marked as invalid, so a new one is created the next time...
January 17, 2011 at 12:05 pm
You can't access that DMV for a particular database. Best thing you could do would be to run multiple queries against sys.dm_exec_waiting_tasks as your queries are running to determine what...
January 17, 2011 at 12:04 pm
Viewing 15 posts - 13,561 through 13,575 (of 22,213 total)