The Best Day Ever to Design a Database Structure
Have you ever been faced with the challenge of designing a new database structure? Do you have to redevelop an…
Part of the
network
network
Tag: performance tuning
Improving SQL Performance
How do you know how much hardware is really needed by your applications? And what do you do when your…
Using Profiler to Identify Poorly Performing Queries
Identifying Long Running Queries is First Step At this step in the SQL Server performance audit, you should have identified…
SQL Server Jobs Can Negatively Affect Performance, If You Are Not Careful
Virtually every SQL Server runs one or more daily jobs. And most likely, runs many weekly jobs. Unfortunately, most DBAs…
SQL Server Application and Transact-SQL Performance
Application and Transact-SQL Code Greatly Affect SQL Server Performance.
SQL Server Database Settings Performance Checklist
Each Database Needs to Be Audited As part of your performance audit, you need to examine each database located on…
SQL Server Configuration Performance Checklist
Most SQL Server Configuration Settings Should Not Be Changed
Operating System Performance Checklist
Like SQL Server, Windows Server is mostly self-tuning. But like SQL Server, there are things we can do to help…
SQL Server Hardware Performance Checklist
Auditing SQL Server Hardware Is An Important Early Step
Configure Windows Indexing Service for Performance
The Windows Indexing Service provides you with the ability to perform advanced searches on directories located on your computer and…
