Brent Ozar's blitz is pretty helpful. Doesn't get you all of the information you specified, but it goes well with a bowl of wheaties

http://www.brentozar.com/blitz/

Just curious, what work are you doing that requires it to be taken offline? You can reboot the active node in a mirrored relationship and assuming nothing breaks during...

Nadrek (1/2/2014)

---

4) Whatever you do, if maintenance windows are a concern, start estimating! How long did it take to do a ~100k page nonclustered index? A ~100k page...

Here is the one I like using. Written by SQLDenis, it helped me quite a bit when I needed to write migration routines between two systems.

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2

I have used RedGate products faithfully for the last 6 year. I recommend it quite frequently to others, and I use it religiously (as I'm writing this reply I...

You can add more files to tempdb without restarting

The link that George Parker posted http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/ is a good place to start.

Basically, observe the size of your log. During a maintenance window shrink that puppy...

Here is a link to Michelle Ufford's post on getting the VLF count

http://sqlfool.com/2010/06/check-vlf-counts/

Another great tool comes from Pedro Lopes

http://blogs.msdn.com/b/blogdoezequiel/archive/2011/07/21/sql-swiss-army-knife-10-vlfs-again-what-s-your-current-status.aspx

Cheers

If your log has experienced lots of autogrowth you might want to check the number of vlfs. I've seen 3 cases in the wild where vlfs have been extremely high,...

I think Bhuvnesh hit the mark. Optimize the indexes on the table if they are poor.

We have some logging tables and the development teams initial fear was to not...

Check to make sure you have set a reservation for the memory in sql. Also see how much memory the host has left over after all the VMs are...

We use office365 and our sys engineer setup a relay for us to use with SQL.

GilaMonster (10/11/2013)

---

George M Parker (10/11/2013)

---

To know whether your value is good or bad, you have to know what "normal" is. That means that you need to have a baseline value...

Check the page count on the indexes that are not defragmenting. SQL Server will not defrag anything 8 pages or less.