MothInTheMachine (6/23/2010)

---

Aha! How I did it was I remoted into the server and opened enterprise manager and ran the alter table statements there. Should I have run EM on my...

@mothinthemachine - Every time something like that happens it's like Perry said, something somewhere has a connection open to the DB and you can't modify it while it's...

NP, good luck and keep fighting the good fight! 😀

How do the specs line up for this new proposed solution? Number of IOPs it's capable of? Number of spindles?

This all needs to be addressed and...

Hey Kwisatz78,

There a multitude of ways to try to prove what your I/O requirements are going to be with a new solution, but I've prescribed to the application of IOPs...

Hey beppe_30,

This may not fully answer your question, but as a general rule, running any database in compatibility mode is simply saying that, although you have a higher version of...

Interesting comments from Quest on this recent change to Spotlight that we got in a webcast invitation to discuss the changes for Spotlight 6.0 and 7.0.

oDisk Queue Length has been...

I don't know...

passivebyz,

We run a mixture of SAN and DAS solutions and the Avg Disk Queue Length is not itself dependent upon the number of spindles in the array. It's an...

+1

Great reply Steve. I've been using a similar script for many years to shrink what we've always referred to as "unruly logs" 😀

Additionally, laddu4700, if you find...

Hey passivebyz,

I've struggled a little myself with the recent change in Spotlight 7.0 from gauging I/O waits based on disk queue lengths to the MAX I/O Wait time per file....

Just for posterity and to prove I'm human, I'll post the outcome.......

Turned out to be that this particular server was a Standard Edition and because we've got 108 SQL Servers...

Faiyaaz,

First check the Job History for the SQL Agent Job that is failing (should have been one or more jobs created by your maintenance plan).  Then check your SQL Server Logs...

Simon, the Alias works just as it sounds. Anytime you reference that server name, the Alias gives you a complete connection "path" to the that specific server. You...

Simon, I'd try running the code/scripts from one of the machines that your having the problem on. Once without an Alias in the Client Network Utility, and once with...