I would use sp_whoisactive (AWESOME freebie found on sqlblog.com) to see real-time query execution metrics (including query plans). I would also use profiler to capture simple execution metrics and...

The usual culprits with all virtualized sql servers apply. Under-provisioning of RAM and especially IO are rampant. Beware a chatty application too unless it is self-contained on the VM.

http://go.microsoft.com/fwlink/?LinkId=306266

http://msdn.microsoft.com/en-us/library/azure/dn133149.aspx

1) use sp_whoisactive to detect right-now activity and metrics

2) use differential wait stats for say 3 minutes to detect waits that occur during that time

3) use differential file IO stalls...

What a TREMENDOUS budget you are throwing at reports that run too slowly!!! I am sure there are a dozen consultants at least on this site that could build...

The network traffic caused by sending in dynamic sql statements should not be anything to worry about. If it is, then you must still be running on 10 megabit...

Please post the entire trigger code, the table schema, sample table data, the update(s) you fire and the expected action by the trigger.

NOTE: I get VERY twitchy when...

mlorek (10/23/2014)

---

Thanks for the replies. Yes we have the funding we actually have a rather large budget and get a educational price break that is amazing. We...

mlorek (10/23/2014)

---

Hi all, I am a dba for a school district. We are purchasing a new application that has a sql backend for both sharepoint and the application. ...

mcforres (10/23/2014)

---

I'm contemplating running two availability groups on a two node WSFC. The WSFC is setup with a file share witness (i.e. no shared storage). Can I safely run...

Glad I could help!

20% frag on a 13GB table could be quite a lot of page swaps. Track the tlog usage for both evolutions and see what the difference is.

Also, doing this...

1) ORs are killers

2) Just spooling 1.5M rows back to a client (especially if that client does row-by-row fetching) can alone be a cause of SIGNIFICANT slowness. Put the...

GilaMonster (10/20/2014)

---

Doesn't work well, the...

If the column-based filters are on the same table I think you can manually create mutli-column statistics to alleviate the problem at hand here. We don't (yet) have multiple-table-multiple-column...

I don't have time to dig through all of that but I will say 2 things:

1) I don't see a table definition that actually has an identity on it.

2) You...