Viewing 15 posts - 16 through 30 (of 31 total)
Thanks for your ideas!
I'm not sure I follow the idea of reversing the order. Won't rowcount always return 1 after an INSERT? (i.e., One row affected).
Note that most of the...
May 6, 2009 at 9:00 am
GilaMonster (5/14/2008)
jamiejulius (5/14/2008)
In reference to the idea of changing the Recovery Model, are you suggesting that this would reduce the frequency and/or duration of the checkpoints?
No. It won't. All it...
May 14, 2008 at 12:17 pm
In reference to the idea of changing the Recovery Model, are you suggesting that this would reduce the frequency and/or duration of the checkpoints?
May 14, 2008 at 8:03 am
Thanks, Gail!
You've been extremely helpful throughout this entire post.
Jamie
May 13, 2008 at 2:33 pm
One more question to help me understand what's happening.
The checkpoint process kicks in as a result of accumulated write activity, which needs to be flushed to the disk. The...
May 13, 2008 at 8:51 am
Thanks for this info.
We're currently on a single disk. We can live with the current situation as is, but if things get worse, I'll follow up on your advice. Thanks!
I...
May 13, 2008 at 8:46 am
Bingo!
I found the following perfmon counter:
SQLServer:Buffer Manager\Checkpoint pages/sec
It correlates exactly with the disk writes.
So indeed my problem seems to be related to the checkpoints.
Thanks to those of you who pointed...
May 13, 2008 at 7:08 am
Hi Gail,
Thanks for your reply. Do you know if there is any logging of the checkpoints, which would allow me to verify that indeed they are associated with what I'm...
May 13, 2008 at 5:15 am
Thanks to all of you who have shared your ideas and suggestions over the last few hours.
Some comments:
1. Some of you suggested that perhaps an external process is responsible for...
May 13, 2008 at 4:55 am
Thanks for the thought.
The DB was set to an initial size of nearly 2GB and an autogrow rate of 1MB. I changed the autogrow rate to 10%.
Unfortunately, this didn't make...
May 12, 2008 at 2:27 pm
Please excuse my ignorance:
1. How do I run the Profiler?
2. What counters do you suggest I monitor with Perfmon?
Thanks,
Jamie
May 12, 2008 at 7:58 am
Thanks for the ideas.
AutoClose and AutoShrink are both set to False.
The performance problem is very brief, so it's hard to look for anything while it's happening. I see the problem...
May 12, 2008 at 7:41 am
Thanks to all for your suggestions.
Specifically, I'm curious about tables with non-clustered indexes. When I do a select, the table and the index need to locked. Likewise an update or...
March 25, 2008 at 5:28 am
Thanks for the comment. Actually I think it helps very much since I'm only asking for the first record which matches.
March 13, 2008 at 9:44 am
Indeed the problem had to do with locking:
I changed the original query to:
select top 1 Name from People with(READUNCOMMITTED) where Status = 0
And it returns a value immediately.
Thanks again for...
March 13, 2008 at 2:06 am
Viewing 15 posts - 16 through 30 (of 31 total)