6 thoughts on “SQL Server Quickie #22 – The Buffer Pool”

1. 

   chris

   05/11/2015 at 4:27 PM

   great video! just as a side note, running this in large environments which a lot of memory , your scripts would fail as you would need to ask the calculation to a BIGINT.

   Cheers for the videos Klaus!!

   Reply
   1. 

      Klaus Aschenbrenner

      05/11/2015 at 7:06 PM

      Hello Chris,

      Hah – nice catch! I have to change that 🙂

      Thanks,

      -Klaus

      Reply
2. 

   Vimal Kr. Prajapati

   06/05/2015 at 2:28 PM

   Nice one. Thanks for sharing.

   I have one question which is not related to this video. Is there any way to know the sql server edition without installing it?? I mean to say I have only exe file and I want to know the sql server edition i.e. it is Enterprise edition or express edition or sql developer edition. How and where we can get this information??

   Thanks in advance!!!

   Reply
   1. 

      Klaus Aschenbrenner

      06/05/2015 at 6:46 PM

      Hello Vimal,

      Thanks for your great feedback.
      Without installing SQL Server I have no idea how to find out the SQL Server edition 😉

      Thanks,

      -Klaus

      Reply
3. 

   Kenneth Igiri

   07/14/2015 at 7:53 PM

   Fantastic in-depth video. Short but insightful. I already have something to use this for once I get my hands on the queries used in the video…

   Reply
4. 

   Prashant

   11/21/2019 at 11:20 AM

   Thanks for knowledge.

   I want to know what action need to take if any table is consuming more memory in buffer pool.

   Thanks
   Prashant

   Reply