Viewing 15 posts - 1,936 through 1,950 (of 4,745 total)
RogueBlackSheep (2/14/2011)
if all your system databases are on 1 drive do a system state backup
using acronis.
If you do this,...
---------------------------------------------------------------------
February 14, 2011 at 3:54 pm
thanks
---------------------------------------------------------------------
February 14, 2011 at 10:36 am
well if you are pointing at physical server names you still need to know which node is supporting which instances or you might wonder why CPU usage just fell through...
---------------------------------------------------------------------
February 14, 2011 at 9:41 am
does it focus down on individual queries as the cause of high resource usage, show query plans, suggest possible improvements?
You say servers must be defined by physical name which is...
---------------------------------------------------------------------
February 14, 2011 at 7:12 am
PHYSICAL_ONLY has its uses with a VLDB or a shortage of time, but should not be used on Every run of checkdb.
---------------------------------------------------------------------
February 14, 2011 at 3:32 am
Grant Fritchey (2/13/2011)
SCOM from MS is good, and certainly enterprise ready. You can get Management Packs that do most of what you're asking about right out of the box. But,...
---------------------------------------------------------------------
February 13, 2011 at 2:38 pm
Grant Fritchey (2/13/2011)
I'd like to repeat exactly what George said...
😀
---------------------------------------------------------------------
February 13, 2011 at 2:34 pm
By all means use something like DPM (note: not personally familiar with this tool) to copy the .bak files off to tape once you have created them on disk using...
---------------------------------------------------------------------
February 13, 2011 at 3:31 am
Anna_SQL (2/12/2011)
For backup failure or job status for many servers, what tool should we use instead to check one by one?
You should monitor these proactively by exception, by which I...
---------------------------------------------------------------------
February 13, 2011 at 3:15 am
Busy tonight Anna? 🙂
Monitoring for what? Performance? Errors? Threshold Breaches? Job failures, Backup failures?
100+ servers is enterprise level so for everything except performance I would go for microsofts own offering...
---------------------------------------------------------------------
February 12, 2011 at 4:20 pm
GilaMonster (2/12/2011)
george sibbald (2/12/2011)
I have probably done it myself without realising it in the distant past, most likely to Gail 🙂
Nah, you and I tend to post within seconds of...
---------------------------------------------------------------------
February 12, 2011 at 4:06 pm
Anna, to repeat verbatim what Gail just said (private joke :-)), and it is probably covered in her webcast, but for me how long you retain your backups on disk...
---------------------------------------------------------------------
February 12, 2011 at 4:04 pm
GilaMonster (2/12/2011)[hrI could locate a couple repeat offenders, but it's not worth the energy right now.
I can think of one who did very well out of it............
---------------------------------------------------------------------
February 12, 2011 at 3:50 pm
Tom.Thomson (2/12/2011)
george sibbald (2/12/2011)
---------------------------------------------------------------------
February 12, 2011 at 3:45 pm
unless i need compression or encryption native utilities all the way. Native backup works extremely well and is a no cost option, so only use a third party tool if...
---------------------------------------------------------------------
February 12, 2011 at 3:32 pm
Viewing 15 posts - 1,936 through 1,950 (of 4,745 total)