• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

July 12, 2018

Page Life Expectancy is the number of seconds the average page of data has been in the buffer pool.SQL server keeps data pages in memory for quicker access instead of having to read from disk every time.

Now, keep in mind that Page Life Expectancy doesn’t prove or dispr...

December 5, 2017

It's important to test your storage performance especially prior to installing or deploying a new SQL Server. 

Microsoft has provided us with a great tool called Diskspd, which was meant to replace SQLIO. Diskspd synthetically generates workloads to run against your ser...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server.  When not working I like to lift weights, play music, and travel with my wife.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle