nm

The system reboots are only during scheduled downtime/upgrades which happen to be every few months. Are you suggesting it is not a SQL issue and maybe something with the O.S.?...

I have 166GB allocated for SQL. 172GB total.

SQLCrazyCertified (1/3/2013)

---

craig-404139 (1/3/2013)

---

No memory issues (We have 172 GB on the server). Log files are not on the same volume as the temp...

I work for a Law firm and each database is a case we are representing. Total we have 10+ TB of data (mdf + ldf size). Initially I thought the...

No memory issues (We have 172 GB on the server). Log files are not on the same volume as the temp db. I've worked closely with our Compellant SAN engineer...

drawlings (12/8/2010)

---

Craig,

You should have no worries with a polling interval of 30 seconds, commercial products dwarf that load.

The next step is determining which counters fluctuate enough to be relevant (for...

I've attached my counters for any feedback as well.

Which is what I have been doing. I started with the basics then added the ones...

We are a SQL 2008 R2 shop and, like others, use a hybrid approach. Maintenance plan(s) for backups and integrity checks and custom jobs for index maintenance.

Robert klimes (11/24/2010)

---

When we bring the virtual machine up since it has an updated copy of master and the same drive letters/pathing it should see the mdf/ldf files and reattach...

Robert klimes (11/24/2010)

---

I am a bit confused now. Your first step says:

I took that as you would be doing a physical to virtual every week. will you...

Robert klimes (11/24/2010)

---

P2V should work fine, I have done it once with a database server a couple years ago and if I remember correctly, did not have to restore any...

Robert klimes (11/24/2010)

---

I am pretty sure that once you do physical to virtual you will not have to restore the databases but you would need to change name and IP...

Robert klimes (11/24/2010)

---

I have a question; when doing a physical to virtual conversion don't all the drives and what they contain get converted to virtual disks thus negating the need...

rudy komacsar - Doctor "X" (11/19/2010)

---

It is a good thing to initially log and notify on this type of message. However there may be underlying storage subsystem issues that need...