Database Recovery

Understanding Wait Stats in SQL Server – A Primer

In this article we look at using Wait stats to discover performance issues in SQL server Facing different types of troubles while working on a database like SQL is a common scenario. In fact, every time, the server is running a query, it starts tracking the duration of time required to be spend on all the bottlenecks. This is where the Wait Stats Feature plays its role. Wait Stats is an interesting and an often overlooked feature of SQL Server Database. These were first introduced in 2005...

Read more »

Quick insights about SQL Server Indexes

In this article we explore the role of Indexes in SQL Server performance One of the most complicated features considered by many working on SQL Database is its indexes. Although, a bit confusing, SQL Indexes play a very important role in your overall performance and you can really work faster and efficiently with some great indexes. On the other hand, poorly managed indexes can make you feel helpless working on SQL database. In this article, you will learn some quick insights about SQL...

Read more »

Looking to Boost Scalability of your SQL Server- Here’s What You Need To Do!

In this article we look at ways to scale up a SQL server implementation Whether you agree or not but deep inside your heart you must be wishing to optimize your SQL Server Database; but since scaling out a SQL Server running on multiple cores is bit difficult you might have hesitated to do so. Good news is that now you can easily boost the scalability of your individual SQL Server and in fact, now scaling up is easier than scaling out. In order to scale your existing SQL Server, you need...

Read more »