26 июня 2009 | Автор: Admin | Рубрика: Компьютерная литература » Програм-ние и разработка » Databases and SQL | Комментариев: 0
Mastering SQL Server Profiler: Brad McGehee
Simple Talk Publishing | ISBN: 1906434158 | March 20, 2009 | PDF (OCR) | 306 pages | 15.16 Mb
SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and
I have been a SQL Server DBA for about 14 years, and I regard Profiler as one of the most useful of SQL Server's "built-in" tools. Profiler records data about various SQL Server events. This data is stored in a trace file and allows you to view the communications sent from a client to SQL Server, in addition to giving you an insight into its internal workings. This information can be used to troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more.
For such a potentially powerful tool, Profiler is surprisingly underused. This must be due, at least in part, to the fact that it is occasionally a frustrating tool. The user interface is poor, it lacks many important features, it is poorly documented and, unless you have a lot of experience as a DBA, it is often hard to analyze the data you capture. As such, many DBAs tend to ignore it and this is distressing, because Profiler has so much potential to make a DBA's life more productive. This is why I wrote this book, Mastering SQL Server Profiler. My goal was to make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems.