Viewing 15 posts - 1 through 15 (of 208 total)
Hmmm - just noticed that the original thread was started in 2012, not 2013! Ho hum. Still, nothing seems to have changed much ...
January 30, 2013 at 7:28 am
Hi Toby,
In case it makes you feel any better I'm in exactly the same situation. I've found a fair bit of info now about the RING_BUFFER_RESOURCE_MONITOR output, but...
January 30, 2013 at 7:28 am
I've now found two production servers that are of identical build and specification (built at the same time using the same standard build images, identical hardware and storage specs) where...
June 18, 2012 at 6:48 am
It's very peculiar data too. Why would you have NULLs for the ID and name on rows in the same table where the department and salary clearly matter? ...
June 16, 2012 at 3:54 am
If the column isn't indexed, then a single scan will be performed. If the column exists in a NC index, but isn't the leading column in that index, then...
June 15, 2012 at 7:28 pm
If you're detaching the databases first, then re-attaching them on the new server should be fine (the upgrade to SP1 will be done automatically as the databases come online). ...
June 15, 2012 at 6:48 pm
Just to confirm Sfallen - is it just the Buffer Node PLE counter you're seeing this on (even on single-node VMs), or do you see similar behaviour on any other...
June 15, 2012 at 7:47 am
Just noticed - I've posted this in TOTALLY the wrong section! Should be under SQL2008. Damn. Anyone got any idea how I move it?
June 15, 2012 at 6:03 am
Ah - interesting. I'm wondering if this is odd behaviour because of the very high spec of the hardware we use and the workload it's under. I'd rather...
June 15, 2012 at 4:29 am
I agree Grant, and it's not something I ever noticed when we used to monitor with Perfmon, so I suspect it's either a) a quirk of the dm_os_performance_counters themselves, or...
June 14, 2012 at 7:30 am
You'll need to suspend replication whilst you do it, but as long as you don't change the PK definition (i.e. column list) you should be OK.
June 14, 2012 at 6:18 am
Do you actually have a default instance on your computer? Localhost will be trying to connect to a server called "Mycomputer" (i.e. your computer name). You SQLExpress...
May 13, 2012 at 6:41 am
Daniel Smith-480684 (9/21/2011)I make that assumption because I think that using DBCC ShrinkFile won't reduce a file below it's initial size.
ShrinkFile will reduce a file below its original size if...
September 21, 2011 at 1:48 pm
Two things strike me reading this:
1. I presume you're not actually out of disk space yet, so what will you gain from actually shrinking the data file? By deleting...
September 19, 2011 at 8:48 am
Yes, but doing a CONVERT on the column (field) is nasty because out there in the real world it'll stop the optimiser from using an index on that column.
I'm not...
August 6, 2011 at 8:51 am
Viewing 15 posts - 1 through 15 (of 208 total)