You might take a look at the RML Utilties from Microsoft. They can help you interpret the information from a trace.

It's not necessarily a problem. It's just another indicator. I'd see if you have other indications of performance problems, excessive waits or queues, long running queries, that sort of thing....

I agree with Gus, I suspect parameter sniffing, although with something this complicated... it's hard to be sure. Get the execution plan for the procedure and the query and see...

Yes, absolutely. Assuming the default trace hasn't been overwritten, that's exactly the type of information it captures.

We're actually going through the process of evaluating both right now. However, we're going with SharePoint, so the question is Reporting Services or Cognos, integrated through SharePoint, not simply Cognos...

For those interested, the book on development will be released here[/url].

Yeah, this is where it will be[/url] when they post it.

Jack Corbett (11/5/2010)

---

Grant Fritchey (11/5/2010)

---

We've been doing this for years. It works really well. I detail a bunch in the book that's getting released from Red Gate next week. In...

Posted. Hope that helps.

We've been doing this for years. It works really well. I detail a bunch in the book that's getting released from Red Gate next week. In a nutshell, you deploy...

Chris Morris-439714 (11/5/2010)

---

GSquared (11/5/2010)

---

CirquedeSQLeil (11/4/2010)

---

Grant Fritchey (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about...

I used...

GSquared (11/4/2010)

---

GilaMonster (11/4/2010)

---

The 'informal conversation' today (3rd time same issue) had the Project manager...

Can you do this? Yes, you can. Since it's only a dev server it shouldn't be too large a problem, but you really do have three things that don't like...

One other thing, SQL Server 2008 does give you some ability to help with dynamic SQL. You can set the server to "Optimize For Ad Hoc Workloads." Here's a description...