文档介绍：A technical Journal for the and munities
Scheduled Jobs and Disk Contention 6 Locking, Blocking and Deadlocks 13 Discovering SQL Server 20
GUID Performance 23 What’s Wrong With GUIDs 25 Understanding Forwarding Pointers 26
Is Your Database Secure? 28 PASS 31
Visit us on the World Wide Web at
MAY/JUNE 2005 ISSUE
A publication of The Central Publishing Group
HE SKY IS THE LIMIT!
Managing Editor:
Susan Page T
Copy Editor: This month we decided to tackle performance in SQL Server.
Susan Page Always a hot topic that’s on everyone’s mind. Usually your
Tech Editors client’s because they want it to be better and yours
Frank Scafidi Rob Anderson because, well, they keep calling you to request you make it
Doug Odegaard Syed Rehman better. :)
Typesetting and Layout:
Erin Agresta To that end we’ve included a look at a variety of perform-
ance related topics. We have a great article on disk con-
Printing: tention with multiple tasks running. While the article looks at
NBS-NorthBrook Services scheduled jobs that may conflict, any large processes,
Advertising scheduled or not, might have similar issues. Greg Gonzalez,
advertising@ architect of sqlSentry, has written a fantastic reference
Subscriptions and address changes: about your disk system and one that you should use to
For subscription and address changes, email examine the periodic slow performance of any server, look-
******@. For renewals, you can ing for overlapping processes.
extend your subscription at ww./store.
We also have noted author Rahul Sharma’s look at locking,
Feedback:
blocking, and deadlocks. This is one that will probably teach
editor@
anyone something about this fundamental database
Copyright process; I know I learned a couple things when reading it.
Unless otherwise noted, all programming code and arti- We also examine the performance of GUIDs, a topic that I
cles in this issue are the exclusive copyright of The Central have not seen anything about, de