Welcome to TechNet Blogs Sign in | Join | Help

Performance (RSS)

Tuesday, January 03, 2006 10:12 AM

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
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, September 12, 2005 10:27 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Tuesday, September 06, 2005 6:11 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Wednesday, August 31, 2005 10:34 AM

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
posted by Mat_Stephen | 1 Comments
Filed Under: , , ,
Tuesday, August 30, 2005 4:27 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , , ,
Thursday, August 25, 2005 1:23 PM

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
posted by Mat_Stephen | 1 Comments
Filed Under: , , ,
Friday, August 19, 2005 2:20 PM

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
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
Friday, August 19, 2005 1:16 PM

Microsoft SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertainty

Max degree of parallelism is an advanced configuration option in SQL Server about which many question have been asked and much written.  In this blog entry I hope to offer some insight and certainty as to what this option does and how it should be
posted by Mat_Stephen | 1 Comments
Filed Under:
Friday, July 22, 2005 2:15 PM

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
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
Tuesday, July 12, 2005 10:48 AM

Blogcast: SQL Server 2000 - Using the Index Tuning Wizard

Another blogcast from the States covering performance tuning in SQL Server 2000, this one covers using index tuning wizard. 6 mins 47 secs http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_2.asx
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Thursday, June 23, 2005 5:40 PM

Cool new OVER Clause (Transact-SQL) in SQL Server 2005

Cool new OVER Clause (Transact-SQL) in SQL Server 2005 to circumvent the not so efficient correlated subquery. Imagine a table: create table grades( StudentID int not null,StudentName varchar(10) not null,Subject varchar(10) not null,Score 
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
Wednesday, June 22, 2005 9:31 PM

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05   Question; how does a snapshot database perform compared to the original database when it comes to querying – can it make use of
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Monday, June 20, 2005 5:47 PM

Blogcast: SQL Server 2000 Performance Demo 1-3 Managing indexes

Here's a Blogcast, the third in a series of three from the US, looking at Performance tuning techniques with SQL 2000 'Managing indexes' http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-3.asx
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Monday, June 20, 2005 5:44 PM

Blogcast: SQL Server 2000 Performance Demo 1-2 Analyzing an execution plan

Here's a Blogcast, second in a series of three from the US, looking at Performance tuning techniques with SQL 2000 'Analyzing an execution plan' http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-2.asx
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Monday, June 20, 2005 5:40 PM

Blog cast SQL Server 2000 Performance Demo 1-1 Searching and browsing objects

Here's a Blogcast, one of a series of three from the US, looking at Performance tuning techniques with SQL 2000 http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-1.asx
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
More Posts Next page »