Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2008 Internals and Troubleshooting
This is the forum to discuss the Wrox book Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort; ISBN: 978-0-470-48428-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2008 Internals and Troubleshooting section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 28th, 2011, 03:07 AM
Registered User
 
Join Date: Aug 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Server-Side SQL Trace

Hello all,

I tried to analyse a process ouf our merchandise management system with the help of the modified PerfStatsScripts which are provided through this site.
I used the SQLDiagPerfStats_SQLNexus.XML. I know that a lot of data is gathered then.
My problem is that the process (or better the app initiating the process) I want to analyse times out when SQL:StmtStarting and SQL:StmtCompleted are gathered as well.
But I am interested in these data among the other.
So, how can I tweek the SQL Trace (or maybe provide additional Ressources to the VM hosting the SQL Server) to get all necessary information for SQLNexus to analyse. I need to take a look at Unique Statements Report. Unique Batches do not provide enough inofrmation in this case.

Regards
Dirk
  #2 (permalink)  
Old January 28th, 2011, 06:51 AM
Brent Ozar's Avatar
Wrox Author
 
Join Date: Feb 2010
Location: Chicago, IL, US
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If I understand your post right, you're trying to analyze timeouts? You said "times out", but I think that's what you meant. SQL Server doesn't know about timeouts because they happen on the client side - the app waits too long and gives up.

Ken Henderson has a good post about how timeouts work:

http://blogs.msdn.com/b/khen1234/arc...20/483015.aspx
__________________
---
Author: Professional SQL Server 2008 Internals and Troubleshooting
Blog: BrentOzar.com
  #3 (permalink)  
Old January 28th, 2011, 07:23 AM
Registered User
 
Join Date: Aug 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Brent,

I think I have to improve my English a little bit. Sorry that my words caused some confusion.

I wanted to analyse one business process of our management merchandise system which timed out when I ran a trace with SQL:STMTStarting / STMTComplete & SP:STMTStarting & SP:STMTComplete.

I had the chance to give my test machine more resources (e.g. added two more virt. CPUs and 4 GB additional RAM).
Now Christian´s custom SQLDiagPerfStats_SQLNexus.XML for sqldiag does not let the process time out any more and I can take a more detailed look at it.
I just thought that there´s maybe another way instead of adding more ressources.

But thank you for the reply anyway. I didn´t expect such a quick response.

Regards
Dirk
  #4 (permalink)  
Old January 28th, 2011, 07:30 AM
Brent Ozar's Avatar
Wrox Author
 
Join Date: Feb 2010
Location: Chicago, IL, US
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ah, okay. Yes, SQLdiag and tracing can add more load than a slow server can handle. You might check into Extended Events, which lets you monitor with less overhead. It requires more work to implement, though.
__________________
---
Author: Professional SQL Server 2008 Internals and Troubleshooting
Blog: BrentOzar.com
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Converting Client-side to Server-side Code kwilliams ASP.NET 2.0 Professional 1 November 21st, 2007 04:25 PM
Firing server side events at client side codes mehdi62b ASP.NET 1.0 and 1.1 Basics 6 May 18th, 2005 09:11 AM
sharing a server-side variable with client-side pigtail Javascript How-To 6 November 4th, 2004 01:01 AM
Two Client Side vs Server Side issues Milo Classic ASP Professional 5 May 25th, 2004 02:47 PM
Accessing Server Side Data on Client Side steve456 Classic ASP Professional 3 October 15th, 2003 02:33 PM



All times are GMT -4. The time now is 12:15 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.