Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...
How to ensure that SQL Server databases do not have fragmented indexes
read more
Microsoft SQL Server
How to monitor the health of SQL Server database instances
Determine the health of instances by collecting real-time statistics. Such statistics include backup devices, databases, error logs, locks, logins,...
How can you tune the performance of SQL Server by analyzing the past to predict the future?
The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is...
What are the five essential SQL scripts for SQL Server performance tuning?
Performance tuning is a complex subject and one of the most critical. Every manager wants their server to run faster. And every database...
Where do you start with SQL Server performance tuning?
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
Cloud Day 2—High Availability and Disaster Recovery in the Cloud
One of my favorite topics in cloud computing is disaster recovery. A decade ago, if you wanted to have true disaster recovery across multiple...
How did a large enterprise, banking company in the USA achieve better system uptime and usability?
Mizuho Securities is a large enterprise banking company in the USA. They have 100 to 499 SQL Server databases in their environment. They suffered...
How are you tuning SQL Server in the hybrid cloud?
As organizations migrate their databases to the cloud, database administrators need to manage databases on-premise and in the cloud with existing...
How did a medium enterprise healthcare company in the USA proactively troubleshoot SQL Server issues?
Methodist Hospitals of Dallas, Inc. is a medium enterprise healthcare company in Dallas, Texas, USA. They have 10 to 24 SQL Server databases in...
How can you improve the performance, disaster recovery, and security of SQL Server?
SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments -...
How did an IT consulting firm save time and money on performance fine tuning for SQL Server?
When companies are looking for a SQL Expert to help with performance challenges, they turn to Oregon-based consulting firm Lake IT for experienced...
How did a healthcare company in South Africa fix a slow and erratic SQL Server?
An IT company that deals with the healthcare industry in South Africa develop a variety of software products, which cover a wide range of...
What do IDERA’s customers have to say about SQL Doctor?
Are you curious about who the customers of SQL Doctor are in terms of the organization, industry, and country? What is the size and the deployment...
How are you tuning the performance of SQL Server, Azure SQL Database, and Amazon RDS for SQL Server?
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance...
How to monitor SQL Server performance with SQL Diagnostic Manager for SQL Server
The monitoring of SQL Server environments is much more straightforward with quality monitoring applications. The proper monitoring applications can...
How to add SQL Server instances to SQL Diagnostic Manager for SQL Server
With SQL Diagnostic Manager, monitor the performance of the entire SQL Server environment by quickly and easily adding SQL Server instances. There...
Why is database backup compression better than file deduplication?
Database administrators often argue with their storage administrators about not compressing database backups. Storage Administrators state that they...
How to create custom counters with SQL Diagnostic Manager for SQL Server
Every environment is different. SQL Diagnostic Manager has pre-configured metrics that it monitors and collects...
How to run prescriptive analysis with SQL Diagnostic Manager for SQL Server
SQL Diagnostic Manager distinguishes itself from typical monitoring tools because it is more than just a symptom-based monitoring tool, since it can...
How to configure metric thresholds and baselines with SQL Diagnostic Manager for SQL Server
In SQL Diagnostic Manager, whenever a metric exceeds the configured value or threshold, the state of the metric changes and it can execute an...
How to configure alert actions and responses with SQL Diagnostic Manager for SQL Server
One of the more innovative components in SQL Diagnostic Manager is the alert actions and responses. This is the part of SQL Diagnostic Manager that...
Who uses SQL Admin Toolset and what is their experience?
Are you curious about who the customers of SQL Admin Toolset are in terms of the organization, industry, and country? Are you curious about what the...
FluidShell – A Primer – SQL Server Edition
Welcome to this first of three blog posts that would cover the basics of getting practical usage of Aqua Data Studio's FluidShell. Introduction:...
How to plan capacity, monitor Always On availability groups, report, and integrate with PowerShell with SQL Diagnostic Manager for SQL Server
SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance...