HanShi (5/14/2013)

---

No databases will go offline. It wil generate error level 17 messages stating "object xx can't be created in filegroup yy for database TempDB" and the transaction(s) will be...

Do the right thing. Setup and build your Cluster from scratch. Then back up and restore your user databases, including msdb.

Test IO with SQLIO before going live and of course,...

Is Resource Governor supported on SQL 2012 Standard edition? 🙁

I spent a lot of time testing today, Dev environment, and it looks this feature is only available on SQL 2012...

homebrew01 (5/10/2013)

---

Bigger picture: Propose to management that a reporting database be created and updated (preferably on a different server) and let users query against that database instead. Still not ideal...

Jeff Moden (5/10/2013)

---

sql-lover (5/10/2013)

---

Jeff Moden (5/9/2013)

---

I wouldn't do any of that because it doesn't address the basic problem of users writing bad code for their reports. Instead, find the...

Jeff Moden (5/9/2013)

---

I wouldn't do any of that because it doesn't address the basic problem of users writing bad code for their reports. Instead, find the users that are...

GilaMonster (5/9/2013)

---

sql-lover (5/9/2013)

---

Killing those ad-hoc queries after X minutes will release the IO pressure. So instead of hammering the SAN for 5+ minutes, if they are not done my 1...

jhager (5/9/2013)

---

Hi,

My shop is running 2008R2 SP2. Our monitoring tool indicated large tempdb data file growth over a short period, then later showed over 90% free space. We are trying...

GilaMonster (5/9/2013)

---

Correct, it's CPU and RAM, but how does killing a query that's done a lot of physical IO help? The IO's already done by the time you kill the...

GilaMonster (5/9/2013)

---

Kill no.

As for how it works, it would take a few pages to explain, so maybe have a read through the entries in BoL (there's a load of...

Hi there...

Lynn Pettis (5/9/2013)

---

Don't have time to help with the query itself, but I noticed you are using sys.sysprocesses. This is a SQL Server 2000 system table and is for...

timscronin (5/9/2013)

---

Doing first 2012 active/passive cluster install. On the screen which looks the same as 2008 where it needs to validate the cluster network I put in the IP I...

ginolard (5/7/2013)

---

Sorry to hijack but we are experiencing a similar issue on our 3-node cluster. Two of the disks attached to an HP MSA SAN reguarly "lose ownership".

The iSCSI...

Today...