dajonx (12/22/2010)

---

Thank you. Do she have an account on here where I can attempt to contact her?

Unfortunately, we do not have a SAN. However, we are...

Another thought... just based on the level of pain, have you checked that your disks are aligned properly? It's not usually an issue, but if your local machine is running...

That's not a problem I've had to solve, but the winner of this year's Red Gate Exceptional DBA Award, Tracy Hamlin, deals with databases even larger than the one you're...

Right back at you and to everyone.

Yule just past, but Kris Kringle still has yet to visit...

Piling on a bit, I agree. You just need to do fundamental data collection of the performance metrics. Use perfmon or, if you have a little money, you might pick...

Once you know the CPU is high, I'd start drilling down on what's causing it to be that high. What processes are using it up? I'd go to the DMO...

This is one of those places where the Microsoft documentation, best practices and advice is the best place to go for information. They really do lay out the choices correctly....

Before you put different applications within a single database, I'd check to see just how much cross-dependencies there are between the apps. Do they share tables & procedures? If so,...

It's pretty likely you're using one of the non-deterministic calls within the function. Check here to validate that.

You shouldn't be getting divide by zero errors when estimating the size of a row. If you are it's down in the estimating how much data per page calculations, which...

If you're just trying to execute the create statements as a batch, SQLCMD is the tool.

You could, with only a little bit more work, take advantage of PowerShell for...

But understand, you're holding open the transaction, locking resources, possibly blocking other users while that wait is in place. It could be a very dangerous thing to do.

What exactly is...

You can also get into more arcane, and expensive, approaches that will solve the problem. Are you on a SAN? Most SAN systems these days can do a transactionally aware...

ALZDBA (12/20/2010)

---

just my 2ct.

With regards to a log shipped db, connections will have to be modified at switch time !

With regards to a mirrored db solution, you prepare all...

Elliott Whitlow (12/20/2010)

---

Well Grant can correct me if he feels it necessary, but there are very few cases where I would want to setup mirroring, I'm really hesitant about the...