SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

AlwaysOn Availability Groups Generate Network Traffic with No User Activity

  Author: Kevin Cox Contributors:  Min He,Steve Lindell Reviewers: Sanjay Mishra, Juergen Thomas, Jimmy May   Creating an availability group needs pings and status checks across the different servers involved. This accounts for approximately 500 bytes per database in the group.  The PerfMon counter used to track the activity is “Bytes Received from Replica/sec”.  Books Online… Read more

Maximizing SQL Server Throughput with RSS Tuning

Author: Kun Cheng Reviewers: Thomas Kejser, Curt Peterson, James Podgorski, Christian Martinez, Mike Ruthruff Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. For more details about RSS improvement on Windows 2008, please check out the whitepaper –… Read more