locked
Sql Services Idle after some time RRS feed

  • Question

  • Hi 

    I have a server with sql express 2008 installed on it. 

    2 Client machines A and B on the same LAN.

    I have a frontend application installed on both Clients A and B which access dB on server to fetch requested data.

    Issue is, if I leave all three sysems idle for 30 mins, the first transaction on dB takes longer than usual time to fetch data.

    Whereas if application is already being used on say Client A and B has been idle for 30 mins even then Client B's first transaction on Server returns data immediately.

    I feel my server goes on idle mode in case of no request from any client for thirty mins.

    Please help

    Monday, January 7, 2019 9:10 AM

Answers

  • It sounds like "auto close" is turned on.

    Please see:

    https://www.brentozar.com/blitz/auto-close-enabled/

    • Proposed as answer by Teige Gao Wednesday, January 9, 2019 8:12 AM
    • Marked as answer by Olaf HelperMVP Friday, September 27, 2019 1:11 PM
    Monday, January 7, 2019 1:37 PM

All replies

  • Do you see time outs --- I mean a client throws that error?

    People sometimes develop their app to open the connection once and keep it open for the life of the app... whether the user uses it or not. 2) killing idle connections would kill the purpose of connection pooling, where connections are "closed" but held on until a new request comes.


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Monday, January 7, 2019 10:00 AM
    Answerer
  • It sounds like "auto close" is turned on.

    Please see:

    https://www.brentozar.com/blitz/auto-close-enabled/

    • Proposed as answer by Teige Gao Wednesday, January 9, 2019 8:12 AM
    • Marked as answer by Olaf HelperMVP Friday, September 27, 2019 1:11 PM
    Monday, January 7, 2019 1:37 PM