Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2000 » Performance   (RSS)

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

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

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

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

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

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

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

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

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
 
Page view tracker