Post reply

question related to inmemory

  • November 16, 2017 at 1:40 pm

    #402675

    Hi Guys,
    quick question,
    1) do we have any use case who are using tempdb in memory?I know the temp objects already reside in memory but just want to know if anyone configured the full tempdb in memory and what was the outcome of it.

    This is specific to SQL 2014 so please help me with your observation if you implemented it.

    ----------
    Ashish

  • November 17, 2017 at 3:04 am

    #1968477

    You can't use in-memory OLTP with tempDB. Not directly.
    You can use in-memory tables in place of table variables, but that's considered to be part of the user DBs, not TempDB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 17, 2017 at 7:20 am

    #1968518

    Thanks Gail.
    But why there is a restriction that the tempdb cant be put completely in memory? The reason is most of the temp objects already residing in the memory and will remain there till they forced to be out due to any memory pressure.

    ----------
    Ashish

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply