Viewing 15 posts - 631 through 645 (of 1,790 total)
Glad to be of help. Wish I could say that it never happened to me but I have left that off a time or two and impacted users as well....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 8:40 am
Read my previous post. Your index rebuild statement was not indexing online and would thereby kill any activity on the table being indexed.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 8:35 am
ichbinraj (5/5/2009)
I am running this following statement on my production . which is critical production box
I want know before running this statement on my box in the evening...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 5, 2009 at 8:27 am
Agreed, SAN "snapshotting" is the way to go, especially considering the growth that you are looking at. Interesting struggle that you are running into with your vendor, somewhat disappointing to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 4, 2009 at 7:54 pm
On the two 2008 instances that I have I show the checkpoint process there all the time on both. The one is working fine as I mentioned in my previous...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 3:27 pm
Marios Philippopoulos (5/1/2009)
I'm getting 0 Checkpoint pages/sec
You should see that counter reading 0 for the most part but then periodically it should shoot way up as the checkpoint process actually...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 2:57 pm
Can you post information on the partition scheme and function as well? Did you partition both the _archive and _live tables?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 2:34 pm
Marios Philippopoulos (5/1/2009)
I can actually do backups of the db on which the CHECKPOINT is running and run DBCC commands.
It seems the CHECKPOINT session is just hung and is not...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 2:21 pm
David Benoit (5/1/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 2:19 pm
I can't view that zip file. Not sure why. What are you zipping it with? If I just click on it I get an xml view of the plan in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 1:50 pm
george sibbald (5/1/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 1:29 pm
balbirsinghsodhi (5/1/2009)
I rename to zip file because this website does not upload sqlplan file. please rename back to sqlplan extention so that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 1:27 pm
Are you suffering from IO latency? Also curious what your CPU looks like. Can you provide some of that information?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 1:26 pm
I'm a pretty visual person so, could you attach the estimated (or actual) execution plan. Under Query > Display Estimated Execution Plan (or Cntrl L). Right click in the plan...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 12:45 pm
This definitely seems like a "case for cursors". 🙂 They're not always bad, especially for maintenance tasks. As GSquared stated you could execute log backups periodically if needed to avoid...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 12:41 pm
Viewing 15 posts - 631 through 645 (of 1,790 total)