Viewing 15 posts - 13,951 through 13,965 (of 22,227 total)
Let me put a question back at you. Since most of the topics you outline have extensive documentation, courseware, books, etc., how do you propose getting developers to that information?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 8, 2010 at 11:36 am
You might take a look at the RML Utilties from Microsoft. They can help you interpret the information from a trace.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 5, 2010 at 12:21 pm
For those interested, the book on development will be released here[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 5, 2010 at 8:05 am
Yeah, this is where it will be[/url] when they post it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 5, 2010 at 8:04 am
Jack Corbett (11/5/2010)
Grant Fritchey (11/5/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 4, 2010 at 6:28 am
Viewing 15 posts - 13,951 through 13,965 (of 22,227 total)