Has to be permissions!

Any drive letter detached on the san?

NTFS permission changed?

Anything usefull in the sql error logs?

You'll have to use a job to send you the e-mail which will be 100% customizable.

In the alert ask to start a job, then use my query to generate usefull...

Bob Fazio (9/12/2011)

---

I appreciate the knowledge and the time. I will state that since the changes Friday, we have only 1 query that still runs in parallel and that...

This can take a guess at the avg, min & max cost of the olap queries.

this uses the cached plan so it won't be 100% accurate but for guesstimate avg...

Steve Jones - SSC Editor (9/12/2011)

---

Gianluca Sartori (9/12/2011)

---

No, I'm sure it does not violate the terms: I'm not sure that I want my name on that thread, though.

Thank you and...

Unless Grant has something else in mind I'd go with Cost Treshold at 25-35. I'm going more on the low end here to get more...

The log file is harder to guess. But which such a small DB, I'd probably go with 3X of the sum of the 2 biggest tables.

Why did you split...

Ninja's_RGR'us (9/12/2011)

---

I wouldn't take any decision based on those stats.

The cost threshold is however at 1 with the default value being 5. This might be something I'd...

I wouldn't take any decision based on those stats.

The cost threshold is however at 1 with the default value being 5. This might be something I'd consider...

I'd use a calendar table for this.

Here's mine http://www.sqlservercentral.com/Forums/Attachment8839.aspx

You can edit out the filegroup, I don't put mine on default.

From there on out it's just a matter of using the...

Ok, as I said, not even junior at tuning that big of a server. ...

Tx, and now these 2?

SELECT* FROM sys.dm_exec_query_optimizer_info

Don't do any of the recommendations, it's just very rough guidelines for us.

SELECT

optz.counter

, optz.occurrence

, CONVERT(DECIMAL(18,2),...

Bob Fazio (9/12/2011)

---

The event's usually last between 5-10 minutes.

However, I should have clarified the 4th number. The other three were ignorable waits. In fact, all in...

Why 5 filegroups for this, this is very advanced tuning? Why such a small autogrowth?

With instant file initialization you could go to at least 1 GB

=> http://sqlskills.com/blogs/Kimberly/post/Instant-Initialization-What-Why-and-How.aspx