In some environments,running Fresh snapshot will take ages to synchronise the subscribers with publishers. Even if it is done in…
Microsoft has introduced an interesting and exciting new feature in SQL Server 2008; it is named the Resource Governor. It…
SQL Server divides the total memory dedicated to it into two parts referred to as Buffer Pool and Memory to…
SQL Server Concurrency Terminology Optimistic concurrency control inside the SQL Server 2005/2008 database engine technically means that row versioning is…
If you suspect that your SQL Server instance is having Disk I/O issues, these queries can help furnish proof that…
The query which can be used to identify Top Wait Stats is given below. It is used to Isolate top…
One of the important things I would recommend is not having transaction log VLFs be too large, with 500MB being…
This website uses cookies.