Tag Archives: performance

Wait Statistics……What to worry for?

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

Advertisements
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

Better…..Faster….SQL Server Backups

Ever since I phased out the legacy backup system in one of my recent projects with a centralized SQL Server backup solution, I have been asked by many people regarding the results that I got from the transition. To put … Continue reading

Posted in backup, Best Practices, ms sql | Tagged , , , , , , , | 1 Comment

REDO……How do you do?????

Its been quite a while since my last post, and I am finally breaking the silence streak. The reason it took me this long would be because I was in a dilemma regarding do I continue the Tuning series from … Continue reading

Posted in Best Practices, Oracle | Tagged , , , , , , | Leave a comment