Note to all Readers

Seems like there was an issue with the comments for this blog – I wasn’t getting notified and hence never got to respond. My apologies to all those that commented and never got a reply. If you do have a comment, please do not hesitate to e-mail me by selecting “e-mail Blog Author” Thanks!  

0

SQL Server: SQL Server and Windows “End of Support” Dates

http://blogs.msdn.com/psssql/archive/2010/01/08/important-sql-server-and-windows-end-of-support-dates-you-should-know-about.aspx taken from the blog above, this information is important for all to know: Important SQL Server and Windows “End of Support” Dates you should know about…. There are some important dates about the end of support for specific products and releases involving SQL Server and Windows that I want you to be aware of:…

0

SQL Server Performance Analysis Part V

PART V: “How To” get down to whatever is bringing SQL to its knees… At this point, following the previous Performance Analysis posts, we have arrived to the following conclusions: 1. We know what server / SQL Server build we are dealing with 2. We have checked for all errors SQL Server could have generated…

1

SQL Server Performance Analysis Part IV

PART IV: “How To” get down to whatever is bringing SQL to its knees… At this point, one should know already whether or not they have memory pressure / cpu bottleneck / disk issues (previous blog posts). With that information, we now filter down and look for the cause. What is truly causing SQL Server’s…

1

SQL Server Performance Analysis Part III

PART III: “How To” get down to whatever is bringing SQL to its knees… Now let’s get down to pinpointing the troublemaker: In most cases, when SQL’s performance is degraded, we never know what exactly is causing the issue. In most cases, we also don’t know how to express SQL Server’s performance issue. It is mostly…

0

SQL Server Performance Analysis Part II

PART II: “How To” get down to whatever is bringing SQL to its knees… SQL Server Error Log:   If SQL Server has an issue, this is most likely where you will find an indication to what is going wrong.   This log provides us with lots of information:   1.    The first line tells us…

0

SQL Server Performance Analysis

PART I: “How To” get down to whatever is bringing SQL to its knees…   Having worked with SQL Server for a few years now, I know that one of the most problematic issues is performance. There are many ways however of analyzing SQL Server performance and pinpointing the bottleneck that is causing the issues. The…

0