Scribd Logo
Upload

Welcome to Scribd!

  • 107 views

    Apache Kafka Cookbook

    Uploaded by

    Renato Moreira
    This document contains log entries from SQL Server 2005 running on Server 2003. It shows memory usage statistics and warnings about I/O requests taking longer than 15 seconds. It also notes that the SQL service log was backed up and indicates the SQL server process memory was paged out, which could result in poor performance.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Apache Kafka Cookbook

    Uploaded by

    Renato Moreira
    107 views3 pages
    This document contains log entries from SQL Server 2005 running on Server 2003. It shows memory usage statistics and warnings about I/O requests taking longer than 15 seconds. It also notes that the SQL service log was backed up and indicates the SQL server process memory was paged out, which could result in poor performance.

    Original Description:

    SDGVVV

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains log entries from SQL Server 2005 running on Server 2003. It shows memory usage statistics and warnings about I/O requests taking longer than 15 seconds. It also notes that the SQL service log was backed up and indicates the SQL server process memory was paged out, which could result in poor performance.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    107 views3 pages

    Apache Kafka Cookbook

    Uploaded by

    Renato Moreira
    This document contains log entries from SQL Server 2005 running on Server 2003. It shows memory usage statistics and warnings about I/O requests taking longer than 15 seconds. It also notes that the SQL service log was backed up and indicates the SQL server process memory was paged out, which could result in poor performance.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    Server 2003 STD 64, SP2. SQl server 2005 (9.0.

    4340)

    Error At the Clients

    Error when trying to connect to SQL Manager

    Task Manager before killing the SQL service.


    Server 2003 STD 64, SP2. SQl server 2005 (9.0.4340)

    Logs during the time of the lockup.

    01/23/2013 07:24:32,Server,Unknown,(c) 2005 Microsoft Corporation.


    01/23/2013 07:24:32,Server,Unknown,Microsoft SQL Server 2005 - 9.00.4340.00 (X64) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYBROKER_FOR_RESERVE <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYBROKER_FOR_STEAL <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYBROKER_FOR_CACHE <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Big Gateway <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Medium Gateway <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Small Gateway <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Optimization Queue <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Small Query Memory Objects: Grants=0 Waiting=0 Maximum=12800 Available=12800 Lim
    01/23/2013 03:53:56,spid2s,Unknown,Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 L
    01/23/2013 03:53:56,spid2s,Unknown,Query Memory Objects: Grants=4 Waiting=0 Maximum=3093790 Available=2350353 Lim
    01/23/2013 03:53:56,spid2s,Unknown,Global Memory Objects: <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
    01/23/2013 03:53:56,spid2s,Unknown,Procedure Cache: TotalProcs=176 TotalPages=2387 InUsePages=145
    01/23/2013 03:53:56,spid2s,Unknown,Buffer Counts: Committed=4128768 Target=4134089 Hashed=3490704<nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Buffer Distribution: Stolen=630365 Free=0 Cached=7699<nl/>
    01/23/2013 03:53:56,spid2s,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,OBJECTSTORE_SERVICE_BROKER (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,OBJECTSTORE_SNI_PACKET (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,OBJECTSTORE_LBSS (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,USERSTORE_SXC (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,USERSTORE_OBJPERM (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,USERSTORE_TOKENPERM (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,USERSTORE_DBMETADATA (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,USERSTORE_SCHEMAMGR (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_SYSTEMROWSET (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_EVENTS (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERTO (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERREADONLY (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERRSB (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERDSH (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERKEK (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_BROKERTBLACS (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_STACKFRAMES (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_XMLDBATTRIBUTE (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_XMLDBELEMENT (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_XMLDBTYPE (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_VIEWDEFINITIONS (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_NOTIF (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_TEMPTABLES (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_XPROC (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_PHDR (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_SQLCP (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,CACHESTORE_OBJCP (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SOSNODE (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_HOST (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLQERESERVATIONS (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_BHF (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLXP (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_FULLTEXT (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SNI (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLHTTP (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLSERVICEBROKER (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLCLR (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLSTORENG (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLUTILITIES (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLOPTIMIZER (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLQUERYEXEC (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLBUFFERPOOL (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,MEMORYCLERK_SQLGENERAL (Total) <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Memory node Id = 0 <nl/>
    01/23/2013 03:53:56,spid2s,Unknown,Memory Manager <nl/>
    01/23/2013 03:53:55,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
    01/23/2013 02:41:31,spid2s,Unknown,SQL Server has encountered 36 occurrence(s) of I/O requests taking longer than 15 secon
    01/23/2013 02:34:22,spid2s,Unknown,SQL Server has encountered 11119 occurrence(s) of I/O requests taking longer than 15 se
    01/23/2013 02:22:49,Backup,Unknown,Log was backed up. Database: Advanced<c/> creation date(time): 2009/01/20(10:23:27)
    message only. No user action is required.
    01/23/2013 02:02:15,spid1s,Unknown,A significant part of sql server process memory has been paged out. This may result in a p
    01/23/2013 01:56:45,spid1s,Unknown,A significant part of sql server process memory has been paged out. This may result in a p

    You might also like