If you're a SQL Server DBA who wants to get proactive and organized with performance monitoring and tuning, then this book is for you. Written by a widely read DBA and SQL Server internals expert, Robin Schumacher offers real-world advice, an easy to follow performance strategy, and lots of SQL diagnostics scripts in a superb book that shows how to quickly diagnose and optimize SQL Server performance problems. Robin Schumacher has written the internals for some of the world's most powerful SQL Server performance software, and now he shows you how to make your database servers run as fast as possible.
Provides information on how to quickly troubleshoot Oracle performance problems, covering such topics as designing databases, storage and reorganization, memory usage, and SQL.
Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner.
Written by the world's top Oracle script developers and authors of over 50 best-selling Oracle books, Mike Ault, Don Burleson and Harry Conway shares their personal arsenal of Oracle data dictionary scripts in this comprehensive book.
Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database.
This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems.
As a Vice President at Embarcadero Technologies, Robin Schumacher has written the internals for some of the world s most powerful SQL Server performance software, and now he shows you how to use the most recent advancements in SQL Server ...
This book provides the tools you need to approach your queries with performance in mind. SQL Server Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them.
While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution.
Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance.
Whatever your applications, whatever your role, this book will help you squeeze more performance and scalability out of the SQL Server databases you depend upon.