Deployment Manager from Red Gate handles some of this. I know there are some open source tools, but I don't know of anything integrated. Since most of these are scriptable,...

gsmith 7350 (2/1/2013)

---

We autochart KPI's on control charts to watch for trends, special causes, etc. . Most of these charts are X-bar with R-charts with control limits calculated to +-...

Mark Stacey (2/1/2013)

---

Averages can be misleading, you could have a server idling for 16 hours, and breaking for 8.

A better technique is to have buckets with how long the server...

Look for backup history for any of the databases. The restore dialog might be the easiest if you haven't done it before.

See if you have options to restore transaction logs.

Thanks, George. I'll add it to my list to look into.

One note, if you have a place you think this should be noted, you can file a documentation bug at...

This might help: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx

Essentially this is an area of memory for objects that might need it. This is not the buffer pool and data space, but other memory space.

Licensing is bad with MS. They don't have the scenarios well defined, and lots of licensing people aren't up to speed. If you call back, you might get different advice.

I...

I haven't used Avamar, but if the log file is growing, either you have a growing workload that needs more log space, or the log isn't being marked as backed...

Did you use Configuration Maanger to change the service? Check the log for errrors? If it ones for one instance, it has the rights for service start, but it might...

Thanks for the update. I hadn't noticed that, but it's good to see.

Did you determine this by testing with a an article that doesn't have a timestamp or finding...

Uwe Ricken (2/4/2013)

---

Steve,

that's true. I made my first try in November 2012 and failed. I got the information about my results in january and wanted to retake asap. From Prometric...

If you are sure SQL Server recovers from the VM snapshot, and it should if it's a good, transactionally consistent method of making the snapshot, then you should be fine.

What...

Not necessarily. If...

Paul Brewer (2/3/2013)

---

Prometric are no longer involved in the lab exams, you have to sit them from home using a Lync client and remote proctoring. Thats a signiificant change (for...

Alex Gay (2/4/2013)

---

I found an effective way was to ask "Don't you have coffee to drink?" knowing his mug was empty. "No" replied my boss, falling for my cunningly...