Admin posted on December 4, 2009 20:15
There is a reason why UDFs kill performance   Saw a great blog post [1] on the MSDN blogs regarding query tuning with UDFs; specifically the problem that was addressed is one that many of us have had to deal with, which is having to overcome the effects of a UDF in the WHERE clause of a ... [More]

Lee posted on November 23, 2009 09:37
SQL Rx performance evaluations.   John Paul Cook wrote a blog about the greatness SQL Risk and Health Assessment Program (SQLRAP) the other day, which prompted me to write a similar piece about ISI’s SQL Rx practice for performance tuning and server evaluations as an alternative to co... [More]

Lee posted on October 13, 2009 13:22
You're joking, right?  For a bit of amusement, check out the following KB that came out last week.  I receive emails from the KB alertz folks, and this one cracked me up. SQL Server 2008 976115   The SQL Server 2008 Books Online shortcuts and the SQL Server 2008 Book... [More]

Posted in: SQL Server Performance  Tags:
Lee posted on June 26, 2009 14:11
The acceptable level, or threshold, for you to contemplate   Regarding forwarded records, I did not see anything published on Google!, in Lori Brown’s article in SQL Server Magazine (April 2009), or anywhere else for that matter regarding the level or number of acceptable forwarded re... [More]

Posted in: SQL Server Performance  Tags:
admin posted on June 25, 2009 21:20
A little advice before you rush out and add files   I still see a lot of blogs saying that they still see a lot of blogs, threads, questions, etc. about tempdb database configuration now maybe more than ever. (Liked that one, didn’t you?). As a consultant I have the opportunity to loo... [More]

Posted in: SQL Server Performance  Tags:
admin posted on June 18, 2009 14:25
These “Big 3” let you gauge SQL Server health quickly   Use Performance Monitor often, and consider reviewing SQL Server:Page Life Expectancy, Physical Disk: Avg. Disk sec/Read, and Processor: % Processor Time to estimate the relative well-being of a SQL Server box. These three counters do... [More]

Posted in: SQL Server Performance  Tags:

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog