Do You Enable “Lock Pages in Memory”?
Database Administration,Performance Tuning | March 10, 2011 | 5:52 pmLock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. By default, this setting is turned off on 64-bit systems, and depending on the circumstances, the following conditions could occur when this setting is not turned on: ...read more
Interview with SQL Server MVP Joe Webb
Conferences,DBA Career,SQL Server Connections | | 5:08 pmJoe Webb will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL. Tell us a little about yourself. For the past 16 years, I’ve been self-employed as a database consultant and I regularly work with clients in the areas of business process analysis and improvements, database design and architecture, ...read more
Attending SQLskills Immersion Event on Performance Tuning Next Week
Database Administration | | 4:47 pmAfter attending the SQLskills Immersion Event on Internals and Performance in Dallas two weeks ago, I am fortunate enough to be flying back to Dallas next week to attend the Immersion Event on Performance Tuning. The first week was a whirlwind, and I imagine the second week will be one as well. I just hope ...read more
Interview with DBA Brian Kelley
Database Administration,SQL Server Connections | | 12:03 pmBrian Kelley will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL. Tell us a little about yourself. I’m currently working as a SQL Server DBA and architect for a financial institution. Previously, I’ve been an infrastructure and security architect. I’ve also been writing on SQL Server related topics ...read more
SQL Server Connections Discount Code
Conferences,SQL Server Connections | | 10:07 amIf you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage of the “DevCon1” discount code to save you $200 off the registration. SQLServerCentral.com will be offering their own SQL Server track, with speakers Joe Webb, Jonathan Kehayias, Brian Kelley and Brad McGehee.
SQLServerCentral Best Practices Clinic
Database Administration,Database Maintenance | March 7, 2011 | 11:51 amI have just begun a new article series at SQLServerCentral.com called the SQLServerCentral.com Best Practices Clinic. What is this series all about? Our goal is to experiment with getting community feedback on different ways that the two node cluster that is running the backend databases for SQLServerCentral.com and Simple-Talk.com can be optimized. If you would ...read more
March Question: What’s Your Biggest SQL Server Performance Headache?
Question of the Month | March 1, 2011 | 1:18 amAs DBAs, we have all received a phone call from a database user, asking why the database is so slow. Based on most DBA’s experience, performance is the number one problem users complain about. So for this month’s question, “What’s your biggest SQL Server Performance headache?”, share with us the biggest performance issue you currently face, ...read more
RSS
Twitter
Linked In