Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Microsoft SQL Server 2000 Performance Tuning Technical Reference

Microsoft SQL Server 2000 Performance Tuning Technical Reference (Paperback)

£30.99
Unavailable. No reason given.
Unavailable

Synopsis

Performance tuning a relational database can be engaging yet frustrating, and this guide gives you the practical information you need to configure and tune a Microsoft SQL Server 2000 database for better, faster, more scalable solutions. The authors start with the basics and build upon them to teach the mechanics of performance tuning and how they affect the whole system. This book also shows how to optimize for the underlying operating system and hardware. It's the only book of its kind coauthored by engineers who have worked in the SQL Server performance group. Expert instruction helps you understand these topics: THE BASICS: Architectural fundamentals that affect tuning I/O tuning and RAID storage considerations How to tune hardware, database layout, and configuration parameters Feature enhancements for better ease-of-use, performance, manageability, and reliability. SERVER TUNING: How to use the Microsoft Windows 2000 System Monitor and the SQL Server Profiler to shorten transaction response times. SIZING AND CAPACITY PLANNING: How to model software and hardware usage to predict resource consumption and conduct preconfiguration planning, and how to perform what-if scenarios about workload growth to avoid slow response times. CONFIGURING AND TUNING: How to tune online transaction processing (OLTP) systems, data warehouses, and replicated systems. How to set up your system for high-performance backup and recovery. TUNING SQL STATEMENTS: How to get optimal performance by using Query Analyzer and Profiler to tune SQL statements and stored procedures. How to take advantage of indexes and hints.

Computing & ITDatabasesData capture & analysisComputing & ITDatabasesDatabase design & theoryRelational databasesComputing & ITDatabasesDatabase softwareSQL Server / MS SQLComputing & ITDatabasesDistributed databasesComputing & ITDatabasesObject-oriented databasesComputing & ITDigital lifestyleInternet guides & online services Publisher: Microsoft Press,U.S. Publication Date: 01/07/2001 ISBN-13: 9780735612709  Details: Type: Paperback Format: Books
Availability: Unavailable. No reason given.  

Edward Whalen is an expert in database performance, administration, and backup recovery solutions.

More books by Microsoft Corporation

More books by Edward Whalen

More books by Marcilina Garcia

More books by Steve Adrien DeLuca

More books by Dean Thompson

Leave Review

Delivery

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location 1st Book Each additional book Average Delivery Time
UK Standard Delivery FREE FREE 3-5 Days
UK First Class £4.50 £1.00 1-2 Days
UK Courier £7.00 £1.00 1-2 Days
Western Europe** Courier £17.00 £3.00 2-3 Days
Western Europe** Airmail £5.00 £1.50 4-14 Days
USA / Canada Courier £20.00 £3.00 2-4 Days
USA / Canada Airmail £7.00 £3.00 4-14 Days
Rest of World Courier £22.50 £3.00 3-6 Days
Rest of World Airmail £8.00 £3.00 7-21 Days

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

The Language of SQL
(Paperback)
Larry Rockoff
 
 
£23.99
 
PHP and MySQL Web Development
(Paperback)
Luke Welling; Laura Thomson
 
 
£39.99
 
SQL in 24 Hours, Sams Teach Yourself
(Paperback)
Ryan Stephens; Arie D. Jones; Ron Plew
 
 
£31.99
 
Android User Interface Design:...
(Paperback)
Ian G. Clifton
 
 
£31.99
 
Latest Blog
Why Little Women is the Perfect Christmas Read
15/12/2017

Publisher of the Macmillan Collectors Library, Harriet Sanders, celebrates the arrival on tv this Christmas of Little Women

#FoylesFive: Foreign Languages Part Two
13/12/2017

Our knowledgeable Languages Department have put together a great selection of books, to help share the magic of reading in every language. Here are their Dutch, Russian and Polish selections.

#FoylesFive: The Last Jedi
12/12/2017

As Star Wars: The Last Jedi drops out of hyperspace and into a cinema near you, Matt from our Web Team gives us his selection of the best Last Jedi books.

View all Blog Entries
Twitter
Show/Hide Tweets
© W&G Foyle Ltd