Do not take this for granted, but I think the iSCSI connections won't work (assuming you are using iSCSI). So doing a P2V may break that part and the machine...

Not sure if related ... but let me post anyway ...

Microsoft asked me to enable lock pages in memory while troubleshooting a different issue on my SQL Cluster. After that,...

Run performance monitor for a few days and get some facts. Collect CPU, RAM, latency, page life expectancy and other counters that will give you a clue of what's happening.

You...

jackcoppen (5/29/2013)

---

When i execute sp_helpdb I get to see a list of all database including size. Should I add up all sizes and keep this as a minimum free disk...

niladri.primalink (5/24/2013)

---

[font="Verdana"]Hi All,

Yesterday I installed 2012 and trying to know its features. Here I am facing a problem. I am trying to take back up of my AP database in...

I have used (and managed) SCOM before. Now I am using RedGate Monitor. And let me tell you ... while less powerful and rich, I am extremely satisfied with RedGate....

ErrLog (5/23/2013)

---

We do it during weekends and it usually takes 20 hrs. No additional storage for restore.

But the point is for 1TB database it is taking 20GB tempdb and DBCC...

ErrLog (5/23/2013)

---

DBCC checkDB is filling up the tempDB. Weird fact is we have a database around 1 TB and its taking 20 GB of tempdb but for a 160 GB...

To downgrade, you need to uninstall the whole SQL instance and reinstall the SQL standard version. There is no "easy" swapping keys or in-place downgrade process, sorry.

Be sure to run...

Still having the same issue: SQL refused to start due lack tempdb space, but there is plenty of space there.

tempdb_data LUN is 250GB and it is currently using 20GB of...

Previous post was due lacked of coffee! lol ... plus a long morning at work.

I added myself (temporary) to the LinkedServer security properties. altered the store procedure, and then removed.

Robin35 (5/15/2013)

---

Hi,

I have a requirement to refresh some tables in dev from prod...and we need to do this every week...so i need to automate...

I thought of using SSIS, but never...

riggins13 (5/15/2013)

---

Thanks All,

I agree that more ram is great..when I said against my wishes I should have stated that I wanted to look at the indexes and queries to find...

riggins13 (5/14/2013)

---

I am running SQL Server 2008 R2 SP2 x64 and we just increased the RAM to 32GB (against my wishes) we are not getting the SQL Server has...

GilaMonster (5/14/2013)

---

It is possible to have the mirror a higher version, but as I said it's a stupid thing to do and iirc it takes extra work to even set...