Monthly Archives: March 2011

Do You Enable “Lock Pages in Memory”?

Posted on by

image

Lock 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:

1) Performance of SQL Server could suddenly decreases for no apparent reason.

2) The hardware running SQL Server could suddenly appear to stop responding for a short period of time.

3) Applications connected to SQL Server could time out.

4) Among many others.

Continue reading →

Interview with SQL Server MVP Joe Webb

Posted on by

Joe_Webb

Joe 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, software development, and technical training.

Continue reading →

Interview with DBA Brian Kelley

Posted on by

K_Brian_Kelly

Brian 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 for about 10 years now. When I am not focusing on SQL Server, I am on the ministry staff as a junior high youth pastor at Spears Creek Baptist Church.

Continue reading →

SQLServerCentral Best Practices Clinic

Posted on by

I 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 like to participate in this SQL Server community experiment, please check out this article and provide your feedback.