Viewing 15 posts - 1,381 through 1,395 (of 49,571 total)
Are those the waits over max an hour of busiest time?
Or is that just an unfiltered query again os_wait_stats?
May 29, 2017 at 4:00 am
The thing is, such a script would have to be updated frequently. Probably best if you check the MS sites for what the current supported patches are, then write a...
May 29, 2017 at 3:30 am
I didn't say look at the queries currently executing, and are those the waits over max an hour of busiest time? Can you filter the meaningless waits out and post...
May 29, 2017 at 1:19 am
May 28, 2017 at 11:14 pm
Please note: 10 year old thread.
May 28, 2017 at 11:06 pm
May 27, 2017 at 8:06 am
So you're saying buffer cache hit rates near 100% do not indicate sql is able to get most data from memory?
That's exactly what it indicates. It's what...
May 27, 2017 at 7:36 am
If you want to specify the values for the identity column, you need to set IDENTITY_INSERT on for that table. If you want the identity to automatically assign the values,...
May 27, 2017 at 7:00 am
Nope, nothing useful there.
Most of those counters are only useful if you know what normal is for that server and workload and are looking for the difference from normal.
May 27, 2017 at 6:43 am
May 27, 2017 at 6:38 am
bobba - Friday, May 26, 2017 7:54 AM(over-provisioning of physical cores to virtual processors) .
There's easier ways to cripple server performance, if...
May 26, 2017 at 8:18 am
No.
You need to start with a full backup from before the table was dropped and roll forward.
May 26, 2017 at 6:04 am
May 25, 2017 at 2:14 pm
One of my co-workers went out to PyCon this past week....
May 25, 2017 at 11:57 am
Viewing 15 posts - 1,381 through 1,395 (of 49,571 total)