stevefromOZ (3/9/2012)

---

ahhh, gotcha. Well, you could use predefined MDX, maybe using SSRS still (local reports vs using report server instance). Alternative would be to look at Dundas or...

DiegoPeña (3/23/2012)

---

More about it here: http://www.sommarskog.se/query-plan-mysteries.html%5B/quote%5D

Great article, thanks.

Chris Harshman (3/23/2012)

---

you may want to check if there's a different execution plan used when the proc is called from management studio vs. the application. One of the culprits...

Eugene Elutin (3/23/2012)

---

When you state 30sec in UI vs 1sec in SSMS, are you talking about complete resultset returned and displayed in both cases or, in case of SSMS you...

No network issues. The code is making a call to that specific proc in the same fashion it...

MysteryJimbo (3/21/2012)

---

No set rules. There are hidden performance problems in poorly written queries around partitioned tables so I tend to look at them as more of a data management...

stevefromOZ (3/9/2012)

---

ahhh, gotcha. Well, you could use predefined MDX, maybe using SSRS still (local reports vs using report server instance). Alternative would be to look at Dundas or...

stevefromOZ (3/9/2012)

---

I would probably lean towards dashboard designer in SharePoint2010 if i had access to it, if I was specifically looking to create dashboards. You could definitely still do...

stevefromOZ (3/9/2012)

---

I'd probably call that better way a "front end, user tool", and yes there's several. Oftenthe easiest option is Excel, with 2010 giving you a fair amount of functionality....

Thanks Gaz

So having "Check Existing Data On Creation Or Re-Enabling" set to No...

Did check the logs, but nothing stands out...

No antivirus.

_Beetlejuice (1/24/2012)

---

If you can, I would bring both nodes down. Then power on the one with the problem first and see if the clusters go online, then bring the second...

Any troubleshooting tips?