New Performance Troubleshooting Guide for SQL2005

Many things have changed with SQL 2005, correspondingly we have to change the way we think about troubleshooting performance problems.  The most significant change is the advent of the new Dynamic Management Views (DMV), these are going to take some getting used to and this article helps significantly.  There’s some really good stuff around identifying…

0

Getting to know SQL 2005 Service Broker

Looks likes I’ve got to do a presentation on Service Broker for the SQL 2005 launch – so I’ve been doing some home work on the subject. The best primer I’ve found is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp?frame=true this is refernenced in the webcast http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032263311&EventCategory=5&culture=en-us&CountryCode=US.  Once you’ve got your head round the basics you’ll want to create your ow broker service…

0

SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers

For a long time now Oracle enthusiasts have bashed SQL Server for not having Optimistic Concurrency Controls.  They would demonstrate a SQL Server reader blocking a writer and possibly a writer blocking a reader.  Thus, having appeared to demonstrate that SQL can’t handle these two operations concurrently, they would therefore conclude that SQL can’t scale…

0

SQL 2005 - UPSERT: In nature but not by name; but at last!

SQL Server has long been criticised for not having an UPSERT command, well now in SQL 2005 we have some good news, we have two new TSQL set operators that give us the complex insert/update logic that constitute an UPSERT.  These are INTERSECT and EXCEPT e.g. — UPDATE Destination FROM (Source INTERSECT Destination) — INSERT…

1

Project REAL—Business Intelligence in Practice - great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005.  The leasons learnt from all their work is being continually published to this website http://www.microsoft.com/sql/bi/projectreal/default.mspx in the form of…

0

64 Bit performance v 32 bit performance - some compelling evidence

More and more ITPros are looking for help in deciding between 64 bit and 32 bit boxes, often they are looking for evidence that 64 bit is worth the investment and worth the risk (of adopting a new platform). This link http://www.microsoft.com/sql/64bit/productinfo/winhecdemo.mspx takes you to a compelling demo, delivered at the Microsoft WinHEC 2005 conference, which…

1

Blogcasts: SQL Server 2000 - Configuring System Monitor & Monitoring SQL Server performance & Configuring alerts

Three new SQL Server 2000 blogcasts out of Redmond: Demo 4-1 Configuring System Monitor                     http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-1.asxDemo 4-2 Monitoring SQL Server performance       http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-2.asxDemo 4-3 Configuring alerts                                     http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-3.asx

0

Blogcast: Using SQL 2000 Profiler

Here’s another blogcast in the SQL 2000 performance blogcast series out of the States – this time ‘Using SQL 2000 Profiler’.  This one’s a bit long at 11mins 8secs. http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_3.asx

1