Tag Archives: performance tuning

Wait Statistics……What to worry for?

Answering the message “Hi, yeah, the server is slow. Thanks. Bye.” Continue reading

Posted in ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , | 1 Comment

A Guide To SQL Server Maintenance Plans

General guidelines towards the best approach in creating a maintenance plan for your SQL Server Continue reading

Posted in backup, Best Practices, configuration, ms sql, Performance Tuning, Troubleshooting | Tagged , , , , , , , , , | Leave a comment

Recipe for Disaster

Happy New year to everyone. With a new year, here I start the year with a blog post talking about a common recipe for disaster waiting to happen with your SQL Servers. By default, SQL Server’s databases are installed on … Continue reading

Posted in Best Practices, ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , , | Leave a comment

How To Identify The Source Of Page Splits

In my last post I talked about how one could go about troubleshooting an issue in SQL Server, and today I would like to talk about one of the common issues that most DBA’s come across their professional career, Page … Continue reading

Posted in ms sql, Performance Tuning, Troubleshooting | Tagged , , , , , , , , , , | Leave a comment

Troubleshoot Your SQL Server

Hi Everyone. I wanted to ask a question before I begin my post today. And the question is: When you’re trying to troubleshoot SQL Server, Where do you start looking? This is one of the most hardest question to answer … Continue reading

Posted in Best Practices, ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , | Leave a comment