Viewing 15 posts - 13,936 through 13,950 (of 22,211 total)
You might take a look at the RML Utilties from Microsoft. They can help you interpret the information from a trace.
November 8, 2010 at 11:20 am
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....
November 8, 2010 at 11:17 am
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...
November 5, 2010 at 1:38 pm
Yes, absolutely. Assuming the default trace hasn't been overwritten, that's exactly the type of information it captures.
November 5, 2010 at 1:35 pm
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...
November 5, 2010 at 12:21 pm
November 5, 2010 at 8:05 am
November 5, 2010 at 8:04 am
Jack Corbett (11/5/2010)
Grant Fritchey (11/5/2010)
November 5, 2010 at 7:29 am
WayneS (11/5/2010)
Hey gang - can I get your thoughts on using TFS to deploy database changes?Thanks!
Posted. Hope that helps.
November 5, 2010 at 7:09 am
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...
November 5, 2010 at 7:08 am
Chris Morris-439714 (11/5/2010)
GSquared (11/5/2010)
CirquedeSQLeil (11/4/2010)
Grant Fritchey (11/4/2010)
CirquedeSQLeil (11/4/2010)
November 5, 2010 at 6:51 am
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 the confusion that may drive.
I used...
November 4, 2010 at 4:19 pm
GSquared (11/4/2010)
GilaMonster (11/4/2010)
Lynn Pettis (11/4/2010)
Gail, Sounds like all future informal conversations will need to include a member of management.
The 'informal conversation' today (3rd time same issue) had the Project manager...
November 4, 2010 at 1:45 pm
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...
November 4, 2010 at 6:28 am
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...
November 4, 2010 at 6:03 am
Viewing 15 posts - 13,936 through 13,950 (of 22,211 total)