Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

monitoring - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » monitoring (RSS)

Microsoft SQL Server 2008 R2 Administration Cookbook - Book and eBook expected June 2011. Pre-order now!

Over 85 practical recipes for administering a high-performance SQL Server 2008 R2 system. Book and eBook expected June 2011 . Pre-order now! Multi-format orders get free access on PacktLib , This practical cookbook will show you the advanced administration...

SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same...

SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

Profiler, Perfmon, DMVs & scripts are legendary tools for a DBA to monitor the SQL arena. In line with these tools SQL Server 2008 throws a powerful stream with policy based management (PBM) framework & management data warehouse (MDW) methods...

SQL Server - SSIS package transformation performance issues, follow up

To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance...

How do I monitor problems with replication?

When you setup a program or application then you have equal responsibility to monitor the process/problems too. Similar to this monitoring a replication topology is an important aspect of deploying SQL Server replication. As the process is distributed...

SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance

The subject line of this post is a common factor that every DBA might have (once in lifetime). Performance Monitoring is a big subject when it comes to practice, many factors include such as what to monitor, how often more from here ...

SQL Server 2008 Policy Based Management - managing and troubleshooting policy failures

Policy Based Management (PBM) is an effective system for DBAs to manage one or more instances of SQL Server. Just to give a brief overview of what it consists, it consists 3 components: Policy management for Administrators to create policies Explicit...

RML Utilities (READTRACE/OSTRESS) now supports SQL Server 2008

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to...

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...