|
The Mission
Computation Press, LLC is founded on the premise that admins for enterprise applications need the best possible information to help them in their daily jobs. The following papers are a start to this process.
Frank McBath
Publisher
|
| SQL-DISK-001 |
|
Database Time Outs & What To Do About Them
As of SQL Server 2000 SP4, informational messages are written out to the errorlog which enumerate stalls in the disk. The disk may be a single disk or an entire storage subsystem. The message coming out of SQL Server when you have the issue looks like this:
SQL Server has encountered 4507 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [D:\Program Files\Microsoft SQL Server\MSSQL\Data\BIGDB_Data.MDF] in database [BIGDB] (7)
While the message is “informational”, the fact is your database is having very serious performance issues.
This TechNote talks about how databases get IO issues, what they look like, monitoring, and how to architect a solution to solve them.
|
|
| SQL-DISK-002 | Calculating How Often An Index Is Used
In SQL Server 2005
Calculating how often an index is used in SQL Server 2005 can be a tedious process. This paper provides a method for solving this common problem by using the DMV sys.dm_db_index_usage_stats. Additionally we cover the considerations of index usage and disablement in the CRM (Siebel) and ERP (SAP, PeopleSoft, JD Edwards) landscape.
|
| SQL-DISK-003 | Finding Queries That
Kill Your System
The most difficult issue in finding performance issues
usually revolves around just defining what the problem is in the first place. This
article will focus on how to use Profiler to capture the necessary data and
comb through it to define where the issues are and then using the Database
Tuning Advisor (DTA) to solve them.
|
| SQL-DISK-004 | Database and Disk Drive Configuration
This is the deck I give at conferences. It focuses on how to create a scalable database solution on everything from direct attached SCSI to SANs. The deck covers perfmon counters, partition alignment, SQL IO performance testing, proper number of files for space management, etc...
|
| SQL-DISK-005 | Performance Methodology Flow Chart
This PDF is a poster showing how to systematically solve performance issues on SQL Server. It tends to be focused on Oracle Applications (PSFT, JDE, SEBL), but the same techniques apply to all large applications.
|
| SQL-DISK-006 | SQL Server Performance Methodology with Oracle Applications
This deck presents a systematic way of defining and solving performance issues with Oracle Applications. It gives an overview of how disk architecture impacts performance, how to run a trace, and reproduce the queries properly outside of the application.
|
Blog
Database + Disk Drives + Performance
This blog is the sister companion to this press. Just as with anything, you can only go as fast as your slowest part... and with most computing, disk is the slowest piece of the equation. While databases now days are seen as a "utility" or filing cabinet, they still store all of the enterprises most critical data. Poor database performance means the app don't work. It's pretty much that easy.
Traditionally, most papers, talks and blogs focus on each part seperately-- hardware guys focus on their SAN, database guys on query tuning, etc... this blog tries to tie them all together: the application + database + disk drives to give end to end performance and scalability for enterprise computing. We'll try and explore out the different ideas and techniques to put together a robust solution.
|
|