Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 291, trackbacks - 0

My Links

SQLTeam.com Links

News

This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog
 




Archives

Post Categories

About me

Identifying Performance Bottlenecks

Thanks to everyone who attended my "Identifying Performance Bottlenecks" session this morning at DevTeach/SQLTeach. As promised, here is the PowerPoint slide deck I used during the presentation.

Regarding the question of on the performance of LINQ, Bob Beauchemin recently posted a series of blogs entries on the topic. Here's a link.

And here's a link to series of posts on the Dynamic Management Views (DMVs) that Louis Davidson authored.

Cheers!

Joe

kick it on DotNetKicks.com

Print | posted on Wednesday, May 14, 2008 10:47 AM

Feedback

# re: Identifying Performance Bottlenecks

Thenks Joe for the slide.

"Using defaults" is included in the "Causes of bottlenecks". Please explain this.
I am interesed to know more about this. In our project we have "Default value or binding" for all the columns/UDDT. I wish to know, how it causes bottleneck.

Regards,

Suresh
5/19/2008 1:50 AM | Suresh

# re: Identifying Performance Bottlenecks

I'm interesting at this document, ..., but I can't access it.
Can you send it to me at .ppt format, nor .pptx ?

Thanks in adavance, Julio.
5/19/2008 8:33 AM | Julio Vallejo Lafuente

# re: Identifying Performance Bottlenecks

I've got the presentation in a VPC. I'll convert it the next time I boot it up. In the meantime, here's a link to a pptx viewer that will allow you to view the presentation. You'll probably need the viewer at some point in the future anyway.

http://www.microsoft.com/downloads/details.aspx?familyid=048dc840-14e1-467d-8dca-19d2a8fd7485&displaylang=en

Cheers!

Joe
5/19/2008 10:00 AM | Joe Webb

# re: Identifying Performance Bottlenecks

Hi Suresh -

Yes, the using defaults doesn't refer to the default values for columns, but to using the default model database definitions - default location, default size, default growth patterns, etc. In the session I explain this, but when just reviewing it can be a bit ambiguous.

I hope you find the material worthwhile.

Cheers!

Joe
5/19/2008 10:07 AM | Joe Webb

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 1 and 7 and type the answer here:

Powered by: