Post reply

Database Connections

  • June 11, 2008 at 1:38 am

    #122966

    Hi All,

    My problem is that one application is fetching data from MS Access to SQL Server but some times the application goes down.I want to check the number of users and connections to a particular server and database.I want to know whether its SQL Server problem or not.Please Help.

    TIA

  • June 11, 2008 at 1:57 am

    #827104

    What type of application you have written?

  • June 11, 2008 at 2:13 am

    #827109

    Its a java application which fetches the data from MS ACCESS and imports to SQL server database.

  • June 11, 2008 at 2:47 am

    #827117

    Web Application? If yes check the session timeout value.

  • June 11, 2008 at 4:32 am

    #827139

    Hello,

    You can execute sp_who2 to see the connections of the Database.. another way is to use the Activity Monitor.

    Regards

Viewing 5 posts - 1 through 4 (of 4 total)

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