Okay, I noticed the issue by comparing the databases.

The prod db had an index on a table. I'm curious as to why when this one little index is added, SQL...

Well I've been looking it over.

While I do have duplicate hardware, it wasn't certified for clustering. I also don't have a spare set of duplicate hardware to test the clustering....

Oh, that's good advice with the Single vs Restricted. I've just always used Single and maybe once I had an oddity where I didn't have exclusivity.

Bhaskar.Shetty (5/24/2013)

---

How about this solutions...

--- Create a InLine Function with ReportingDate Parameter --

CREATE FUNCTION fnMostRecentOrderDetail(@ReportingDate datetime) RETURNS TABLE

AS

RETURN

(

SELECT ProductId, SalesOrderDetailId, ModifiedDate,

ROW_NUMBER() OVER (PARTITION BY ProductId ORDER BY ModifiedDate DESC) RowNo

...

Hmm, thank you. I hadn't quite thought of that as a third option to the Sub query and cross apply. In fact if I'd made...

Paul White (5/24/2013)

---

This is a variation of the 'Top N per Group' problem, and there are many ways to express it in T-SQL. Whichever you choose, be sure to make...

The First_Value/Last_Value sounds really promising, but I'm not quite getting it yet.

-- Method 1.5a

SELECT DISTINCT

Product.Name

,ReportDate = @ReportingDate

,MostRecentOrderDetailId...

So the bug is that it's not showing the right SQL text?

But using sys.dm_exec_requests and sys.dm_exec_sessions rather than sys.dm_exec_query_stats to get session level data... is that the intention of LongRunningQueries...

I'm not sure that LongRunningQueries is finding long running queries.

It seems like it's finding long sessions.

Every night I run a job that runs a sp that runs a dozen...

gazzer (4/19/2013)

---

I am however having difficulty in getting one of the jobs to run.

Namely

LongRunningJobsAlert

I get the following error message

'Procedure usp_JobStats has no parameters and arguments were supplied'

Had a look at...

File Stats - Last 24 Hours...

I'll look into it, but only the Filename and IO% are populated on my daily health report. Everything else is all 0's.

Ahh, it "was":

Message

Executed as user: NT SERVICE\SQLAgent$WEEKLY. Procedure usp_JobStats has no parameters and arguments were supplied. [SQLSTATE...

Looks like everything but the longest running jobs are working. I got my first daily health check email.

My only feedback for what I'm seeing so far is that it would...

michaelrounds (4/15/2013)

---

I've seen errors like that when I try to run the script more than once in a single query window. There is something funky going on with how the...

This looks very great, but it doesn't seem to work on my systems.

@@Version

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

Feb 10 2012 19:39:15

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on...