Home Forums SQL Server 2005 Administering "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details." RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

  • April 22, 2009 at 12:56 am

    #981966

    SQL Server Performance Monitor -> add counter Total Server Memory(in KB)

    will display how much memory is allocated by an instance of SQL Server

    Memory-Available Bytes

    will display how many bytes of memory are currently available for use by processes.

    Memory-Pages/sec

    will display no of pages in and out to disk. if it is high excessive paging.