sotn (3/2/2012)

---

The results are just in the SSMS query window and I am RDP'd directly onto the server, this is to remove the main application as the cause of the...

GSquared (3/2/2012)

---

Good to know. I haven't had a chance to test that heavy-duty an SSD setup.

I like the idea of heavy-use indexes on local SSDs. Not sure I'd...

Use SQL Server profiler; if the reads, the writes, the CPU, and the results are the same, but the duration is different, that's #1.

Check for internal fragmentation, check your statistics,...

GSquared (2/29/2012)

---

Woudn't bother using SSD for the O/S on a server, unless you haven't got any other plan...

Do you have the drive space to support those indexes? Will you in five years, given data growth?

Do you have the time to create and/or maintain those indexes? ...

Shawn Melton (12/13/2010)

---

Along with VMWare tools you can open a command prompt and type in "systeminfo".

It will spit out a good many lines but go back to the start and...

Nicholas Cain (2/28/2012)

---

To be honest you should never allow a file to autogrow by a percentage. Why Microsoft still push this as the default option is beyond me. You should...

You didn't really provide enough information for us to help you. That said - check for internal (index) and external (filesystem, SAN) fragmentation, check your query plan (you said...

I agree with what Jeff said - if you want the VM to perform consistently, give it dedicated resources (i.e. set the minimum CPU to a reasonably high level and...

You should ask for further business requirements before proceeding. Why they want to encrypt their backups is a critical question.

If they want to check an internal checkbox...

On a separate note, you can use vSwitches (virtual switches) or the equivalent to set up entirely independent networks of guest VM's which have no capability to interact with your...

For anyone wondering "What's wrong...

As the article alluded to, the trick to good worst-case performance with a virtual server is the same as the trick to good performance with a physical server: Share as...

colin.Leversuch-Roberts (2/15/2012)

---

The whole point about backups is that you must be able to recover from them. We don't run our prod SQL on VMWare ( or Hyper V ) why...

Don't forget you need to continue taking Transaction Log backups of databases in Full and Bulk Logged recovery models, regardless.

Also note that different objectives, such as PITR (Point in time...