See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
Analysis Services 2005
Free SQL Server Tools, Utilities and Addins
High Availability and Disaster Recovery
Performance Top Tips
Post Event Follow Up
SQL 64 bit
SQL Server 2000
SQL Server 2005
SQL Server Integration Services
SQL Server Security
Browse by Tags
Mat Stephen's SQL Server WebLog
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...
3 Jan 2006
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...
13 Sep 2005
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...
6 Sep 2005
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...
30 Aug 2005
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...
25 Aug 2005
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.asx Demo 4-2 Monitoring SQL Server performance http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-2.asx Demo 4-3 Configuring alerts http://www...
19 Aug 2005
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 used. Firstly, I must dispel any idea you might...
19 Aug 2005
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
22 Jul 2005
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
12 Jul 2005
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 int not null) With some values: insert into grades...
23 Jun 2005
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 the indexes on the original database? Thanks...
22 Jun 2005
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
20 Jun 2005
More follow up from my TechNet SQL 2005 presentation (14/6/05) - SMP boxes and database files
During my TechNet presentation on Tuesday evening (14/6/05 in Reading), I got a little side tracked and, while talking about partitioning in SQL 2005, found myself drawing my audiences’ attention to the fact that only one thread can access a database file at any one time. This fact being the foundation...
17 Jun 2005
Processing XML Showplans Using SQLCLR in SQL Server 2005 - Make Use of the New XML Showplans
SQL 2005 now provides Showplan (Query plan) output in XML - why? To make it easier for a dba/developer to write TSQL, or other code, that can determine the cost of a query and thus dynamically determine if the query should be prevented from running based on the load it will create on the server. To...
23 May 2005
SQL Server 2000 vs SQL Server 2005 Performance
As SQL server 2005 gets closer more and more people are asking how much faster is it than SQL Server 2000. Thanks to Rog Garrison here's one of the first tests I've seen http://www.sqljunkies.com/Tutorial/077C7BEB-EB31-4A07-923D-BE309F59D0F8.scuk Thank heavens its faster - and it should get faster...
19 May 2005
TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning
For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorks GO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1 ALTER DATABASE AdventureWorks ADD FILEGROUP FG2 GO ALTER DATABASE AdventureWorks ADD FILE...
18 Apr 2005
Its Sunbelieveable: Sun’s First Windows - Microsoft SQL Server SAP Benchmark and Certification
Actually, I reckon it must be Sun’s first Windows - SQL Server benchmark ever, unless you know otherwise? It’s great to see Sun embracing the new Opeteron chip from AMD and coming up with a great 32 bit SAP SD 2 tier 2 proc benchmark http://www50.sap.com/benchmark/pdf/cert0205.pdf Can’t wait till we...
12 Feb 2005
SQL Server Performance Top Tip: SQL Server User Mode Scheduler (UMS) – understanding it can explain some odd performance
When performing batch jobs where you wish to run processes in parallel it is important to understand how the scheduler works. You can get a description of what the scheduler does by looking under the title ‘ SQL Server Task Scheduling’ in Books on Line. However what you need to know is not at all...
11 Feb 2005
Microsoft SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors
Seen this? You’ve got a nice new sparkling multi processor box, packed with ‘go-faster’ chips but the performance isn’t much better than your old one or two processor box. You take a look at the processor usage, either through task manager or Performance (System) Monitor, and notice only one processor...
2 Feb 2005
SQL Server Lock Escalation – Friend of Foe?
Sometimes I hear the comment that someone can’t get their application to scale above 50 – 100 users; above a certain number of users there is a sudden ceiling in scalability. So often I have found this to be a problem with nothing more than SQL Server’s ‘method’ of lock escalation. What is lock escalation...
31 Jan 2005
CREATE proc track_waitstats & CREATE proc get_waitstats - useful code for diagnosing SQL 2000 performance
For those attending my TechNet SQL 2000 performance tuning session at TVP Reading on Tuesday 25th Jan, here is the code for the track_waitstats and get_waitstats stored procedures I refer to during the presentation. CREATE proc track_waitstats (@num_samples int=10,@delaynum int=1,@delaytype nvarchar...
25 Jan 2005
SQL Server Health and History Tool (SQLH2)
This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5. Realising such downloads have sometimes escaped me I’ve decided to subscribe to Download Notifications...
7 Jan 2005
Benchmark your SAN or disk subsystem IO throughput – with SQLIO, free to Microsoft SQL Server users
Benchmarking systems is one of the most important things you can do; amazing how many people don’t do it. Benchmarking your disk subsystem is even more vital; even more amazing how many people don’t do it. Why is benchmarking your disk subsystem so important? Two reasons: firstly, so that when the day...
23 Dec 2004
MSDN Webcast: Application Performance Tuning Using SQL Server Profiler 2005 (Level 200)
Friday, January 07, 2005 - 9:00 AM - 10:00 AM Pacific Time Geoff Snowman, MSDN DEVELOPER COMM CHAMPION, Microsoft Corp. If your system has a performance problem, how do you know whether the problem lies in the application or the database? You need a tool that will let you view interactions between the...
20 Dec 2004
SQL Server can run your enterprise? Here's how to prove it
SQL Server 2000 has to live with the legacy that it was once called SQL Server 6.5 – if a database could have a pain in the neck this would be SQL Server’s. When Microsoft completely rewrote Microsoft Mail it gave it a new name, Exchange; thus everyone assumed it was a completely new product without...
16 Dec 2004
© 2014 Microsoft Corporation.
Privacy & Cookies