Don't shrink your databases regularly. If you need to do this, it's a rare, one-time event as Sean mentioned.

I checked the SQL Servers, but everything seemed to be in order there. I suspect the mail servers had some issue.

Looks like they're working as I just got about 150...

The index stats are cleared out when the server is restarted, so if you have done that, this isn't accurate.

The index stats are a good place to start, however. What...

Arrgggg, my image didn't post.

Trying again

Chris Metzger (12/19/2012)

---

You know I wish more managers\executives thought this way. It makes no sense to emphasize the cert but not the real-world experience - sometimes some of us...

You don't want alerts when CPU > 80%. This happens all the time in a normal SQL Server and it's not a problem. What you want to be concerned about...

In addition to Gus' question, are you going to manually look through this data every two hours? Or are you storing it somewhere? If it's the former, I think you're...

No worries, another one for...

I would tend to agree with Sean. Likely this could be rewritten to function much better and quicker.

What you need to do isn't all that hard, but there are a lot of moving parts. I'd suggest that you tackle this in two ways.

1. Remove public

2. Fix permissions

You...

There are probably better ways, but I think this works:

; WITH AllActions (ItemID, ActionID)

AS

(

SELECT distinct

i.itemid

, a.actionid

FROM items i

CROSS APPLY

( select a.actionid

...

One thing you might examine is your waits for the various files. If you see waits stacking up, then you have IO issues.

A few more references for you:

http://www.simple-talk.com/sql/performance/sql-server-wait-events-taking-the-guesswork-out-of-performance-profiling/

http://www.simple-talk.com/sql/performance/a-performance-troubleshooting-methodology-for-sql-server/

http://www.sqlskills.com/blogs/paul/post/capturing-wait-stats-for-a-single-operation.aspx

The rules are a mess. You can place them (almost) anywhere, which is crazy.

I don't like the idea of them after BEGIN-like statements. I'd see rules as:

Begin try

--do stuff

End try

Begin...

Packages do not necessarily fail on a single error. They can have failure logic built in and still complete, but if an error bubbles up, it is returned to the...

You have a few problems. First if there is more than one .bak file, you have no guarantee of which one your script will find.

Second, you can't include a variable...