Odd. It only throws the warning up when using the GUI.
Run a script to create objects and it's ok.

Hi Alan,

The CMD file works perfectly when run from the local SQL Server, only failing when run through the SQL Agent.
I found the problem. The putty profile...

IGNORE.
I had a moment of clarity.
Still not entirely sure why this behavior happened, but by changing the expression from "Label" to "Value" it now works perfectly.

Eg:...

Chaps!
Many thanks. The problem was my GROUP BY.
Always good to have a second pair of eyes to spot the obvious cock ups 🙂
I simply removed the...

Quick update in case anyone was wondering.
The last 3 comments were spot on.
SSRS came to the rescue and I was able to grab all the data with a...

Thanks guys, that sounds like a plan. I'll try it !

Thanks for the reply.

However the requirement has now changed...

Rather than having the server and disk data displayed together they now need to be on separate lines.

Just to re-iterate...

I have 2...

And you can specify Premium SSDs if you spin up your VM in a region that supports them (eg: Western Europe)

Abu Dina (4/9/2013)

---

Long shot but what's the value for Max Degree of Parallelism set to? if it's still set to the default of 0 I would go with the MS...

MyDoggieJessie (4/9/2013)

---

Also check thet "lock pages in memory" has been set at the OS level, if it isn't you could be constantly swapping it all out between RAM and the...

dan-572483 (4/9/2013)

---

What is the RAM configuration for the production instance? The default setting could lead the SQL using too much RAM, which can trigger page file use. In...

Performance from day 1 was poor and has just got worse.

The 3 biggest are:

wait_type wait_time_spct running_pct

CXPACKET 9290353.1738.61 ...

Blocking isn't (usually) a problem. It does occur occassionally but only when one particular proc runs and doesn't correlate to the issues we see.

Disks are connected via fibre channel.

We also...