Yes, I'm encouraging our Systems Team to open a ticket with Commvault. I don't have access to it but it seems to be designed for one thing: ...

I think we would be safe in making some generalizations. Many companies using sql server just aren't going to budget for a full-time DBA until they reach the size...

Although we have numerous data files and several filegroups in our main prod database, I don't think we could effectively restore a filegroup that would actually allow users to do...

" I wouldn't have to keep putting their tragedies on boxes that could eventually determine the atom count of the sun..." :w00t: ...

Gail, I stand corrected. Just checked our Quest Spotlight tool and it's showing max memory 42GB ( that is our max setting ), with 36.5 for buffer cache and...

I forgot to mention that every time you adjust the memory setting on sql server, the plan cache will get emptied ( not sure about data buffer ), so you...

narasimhareddy, I think you need to give us more information. How much memory does the sql server box have, total? On windows server 2003 we found...

Yes I'm sure we're seeing some queries that belong in a data warehouse. Our "business" side has even insisted that clients be allowed to do "contains/like" type searches where...

Thanks Jeff. I'm taking serious note of all being said here, and passing it to our Corporate DBA for review also. I'm not in a position to...

I'd like to hear more about netapp snap. At this point I'm not sure what is being planned for DR, except mention of some form of replicating the...

Unfortunately I think dropping ORM would take an act of Congress. So far we don't have a data warehouse, but it is being discussed. No use of analysis or...

I think we got approval for about $150k. One advantage of having a DR site is doing your backups on that instead of on the production databases.

I've been using Quest's Spotlight for a couple years and Quest's Performance Analysis for Sql Server for about a year. Performance Analysis ( PASS ) is more of an...

Here are a couple examples of these queries in plan cache, occupying about 2mb each.

insert msdb.dbo.backupset ( backup_set_uuid, media_set_id, first_family_number, first_media_number, last_family_number, last_media_number, catalog_family_number, catalog_media_number, position,...

Yes we're using the lock pages privilege for our sql service account. The queries are apparently run by sql server, sql agent or the Commvault backup tool since they...