Category: Advanced

RSS Tuning Whitepaper notes and clarifications

Post author By Jen McCown
Post date October 19, 2011
Categories In Advanced, Intermediate, Random helpfulness, sqlserverpedia-syndication, SSC

This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning (it came with a catchy SQLCAT logo!) So I clicked, I read, I downloaded and read some more. To summarize (BIG summary!), this paper says that in pre-2008 Windows server, the networking protocol stack didn’t scale well to multiple CPUs because […]

RTFM365, Week 1

Post author By Jen McCown
Post date December 10, 2010
Categories In Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned. Boilerplate: For the next year (-10 days now), I will read from SQL Server Books Online a little every day, and blog about […]