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)

performance - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » performance (RSS)

Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience...

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 - 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...

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; ...more from here;

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 Upgrade issues - How to evaluate potential issues?

During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology...

Free Microsoft Press eBook offer - Introducing SQL Server 2008

Here is the interesting and fantastic news for the SQL Server users, Microsoft Press is offering eBook about "Introducing Microsoft SQL Server 2008" by Industry Experts & SQL Server MVPs - Greg Low, Peter DeBetta & Mark Whitehorn. *...

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...
More Posts Next page »