Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].

问题 OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].

  • Wednesday, February 27, 2013 5:30 PM
     
     
    Sign In to Vote
    0
    Hi,

    Today around 10:16 am on my production Server my linked Servers stopped working with the error
    i checked the error log and recived below errors and a dump file in log folder. After checking the mdmp file from windbg i

    got below info.
    Same error i recieved on in errorlog around 5 pm.
    Below are the configurations on prod Server. Please suggest what is to be done on urgent basis or any more information

    required.
    #######Error while selecting oracle linked Server
    [OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]
    OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:   ].
    Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'MSDAORA' reported an error.  
    ##################

    Configuration:

    OS: Windows Server 2003 R2 Enterprise edition SP2
    SQL Server 2000 Enterprise Edition, 8.00.2305,SP4 32-bit
    max server memory (MB) : 25600 MB out of total 32 GB RAM



    mdmp file
    ********************************************************************
    Symbol search path is: *** Invalid ***
    ****************************************************************************
    * Symbol loading may be unreliable without a symbol search path.           *
    * Use .symfix to have the debugger choose a symbol path.                   *
    * After setting your symbol path, use .reload to refresh symbol locations. *
    ****************************************************************************
    Executable search path is:
    Windows Server 2003 Version 3790 (Service Pack 2) MP (8 procs) Free x86 compatible
    Product: Server, suite: Enterprise TerminalServer SingleUserTS
    Machine Name:
    Debug session time: Wed Feb 27 16:20:16.000 2013 (GMT+6)
    System Uptime: 0 days 10:16:11.812
    Process Uptime: 0 days 10:17:40.000
    ................................................................
    ................................................................
    ..
    Loading unloaded module list
    ...............
    eax=7ffdd000 ebx=00000000 ecx=00000000 edx=00000000 esi=00000000 edi=00000098
    eip=7c82845c esp=000af5d8 ebp=000af640 iopl=0         nv up ei pl zr na pe nc
    cs=001b  ss=0023  ds=0023  es=0023  fs=003b  gs=0000             efl=00000246
    Unable to load image C:\WINDOWS\system32\ntdll.dll, Win32 error 0n2
    *** WARNING: Unable to verify timestamp for ntdll.dll
    *** ERROR: Module load completed but symbols could not be loaded for ntdll.dll
    ntdll+0x2845c:
    7c82845c c3              ret
    *************************************************************




    ErrorLog:

    2013-02-27 10:16:48.58 spid59    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 10:16:57.77 spid75    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 10:16:58.94 spid72    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 10:16:59.29 spid90    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 10:17:04.55 spid83    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 10:17:05.69 logon     Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    2013-02-27 10:17:11.54 logon     Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    2013-02-27 10:17:20.24 spid53    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 10:17:22.21 logon     Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    2013-02-27 10:17:22.74 logon     Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    2013-02-27 10:17:22.93 logon     Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    2013-02-27 10:17:35.21 spid83    Buffer Distribution:  Stolen=2058 Free=643 Procedures=6190
            Inram=0 Dirty=19888 Kept=0
            I/O=0, Latched=231, Other=3247790
    2013-02-27 10:17:35.23 spid83    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3267702
            InternalReservation=182 ExternalReservation=111 Min Free=256 Visible= 173968
    2013-02-27 10:17:35.23 spid83    Procedure Cache:  TotalProcs=1734 TotalPages=6190 InUsePages=2884
    2013-02-27 10:17:35.23 spid83    Dynamic Memory Manager:  Stolen=8391 OS Reserved=1016
            OS Committed=994
            OS In Use=989
            Query Plan=6418 Optimizer=7
            General=2121
            Utilities=51 Connection=271
    2013-02-27 10:17:35.24 spid83    Global Memory Objects:  Resource=1427 Locks=143
            SQLCache=438 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=32
    2013-02-27 10:17:35.24 spid83    Query Memory Manager:  Grants=1 Waiting=0 Maximum=126456 Available=126349
    2013-02-27 10:17:35.24 spid75    Buffer Distribution:  Stolen=1955 Free=656 Procedures=6182
            Inram=0 Dirty=19703 Kept=0
            I/O=0, Latched=237, Other=3248067
    2013-02-27 10:17:35.24 spid75    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3267702
            InternalReservation=182 ExternalReservation=51 Min Free=256 Visible= 173968
    2013-02-27 10:17:35.24 spid75    Procedure Cache:  TotalProcs=1733 TotalPages=6182 InUsePages=2884
    2013-02-27 10:17:35.24 spid75    Dynamic Memory Manager:  Stolen=8386 OS Reserved=1016
            OS Committed=994
            OS In Use=989
            Query Plan=6413 Optimizer=7
            General=2121
            Utilities=51 Connection=271
    2013-02-27 10:17:35.24 spid75    Global Memory Objects:  Resource=1427 Locks=143
            SQLCache=438 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=32
    2013-02-27 10:17:35.24 spid75    Query Memory Manager:  Grants=1 Waiting=0 Maximum=126456 Available=126349
    2013-02-27 10:17:35.21 spid59    Buffer Distribution:  Stolen=1973 Free=643 Procedures=6190
            Inram=0 Dirty=19463 Kept=0
            I/O=0, Latched=239, Other=3248292
    2013-02-27 10:17:35.26 spid59    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3267702
            InternalReservation=182 ExternalReservation=51 Min Free=256 Visible= 173968
    2013-02-27 10:17:35.26 spid59    Procedure Cache:  TotalProcs=1733 TotalPages=6190 InUsePages=2884
    2013-02-27 10:17:35.26 spid59    Dynamic Memory Manager:  Stolen=8384 OS Reserved=1016
            OS Committed=994
            OS In Use=989
            Query Plan=6411 Optimizer=7
            General=2121
            Utilities=51 Connection=271
    2013-02-27 10:17:35.26 spid59    Global Memory Objects:  Resource=1427 Locks=143
            SQLCache=438 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=32
    2013-02-27 10:17:35.26 spid59    Query Memory Manager:  Grants=1 Waiting=0 Maximum=126456 Available=126349
    2013-02-27 10:17:35.27 spid53    Buffer Distribution:  Stolen=2617 Free=656 Procedures=6182
            Inram=0 Dirty=20244 Kept=0
            I/O=0, Latched=231, Other=3246870
    2013-02-27 10:17:35.27 spid53    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3267702
            InternalReservation=182 ExternalReservation=51 Min Free=256 Visible= 173968
    2013-02-27 10:17:35.27 spid53    Procedure Cache:  TotalProcs=1737 TotalPages=6182 InUsePages=2884
    2013-02-27 10:17:35.27 spid53    Dynamic Memory Manager:  Stolen=8386 OS Reserved=1016
            OS Committed=994
            OS In Use=989
            Query Plan=6413 Optimizer=7
            General=2121
            Utilities=51 Connection=271
    2013-02-27 10:17:35.27 spid53    Global Memory Objects:  Resource=1427 Locks=143
            SQLCache=438 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=32
    2013-02-27 10:17:35.27 spid53    Query Memory Manager:  Grants=1 Waiting=0 Maximum=126456 Available=126349
    2013-02-27 10:17:35.32 spid90    Buffer Distribution:  Stolen=1982 Free=654 Procedures=6171
            Inram=0 Dirty=19725 Kept=0
            I/O=0, Latched=239, Other=3248029
    2013-02-27 10:17:35.32 spid90    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3267703
            InternalReservation=182 ExternalReservation=51 Min Free=256 Visible= 173968
    2013-02-27 10:17:35.32 spid90    Procedure Cache:  TotalProcs=1734 TotalPages=6171 InUsePages=2884
    2013-02-27 10:17:35.32 spid90    Dynamic Memory Manager:  Stolen=8388 OS Reserved=1016
            OS Committed=994
            OS In Use=989
            Query Plan=6415 Optimizer=7
            General=2121
            Utilities=51 Connection=271
    2013-02-27 10:17:35.32 spid90    Global Memory Objects:  Resource=1427 Locks=143
            SQLCache=438 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=32
    2013-02-27 10:17:35.32 spid90    Query Memory Manager:  Grants=1 Waiting=0 Maximum=126456 Available=126349
    2013-02-27 10:17:38.66 spid72    Buffer Distribution:  Stolen=2431 Free=868 Procedures=5511
            Inram=0 Dirty=19720 Kept=0
            I/O=0, Latched=237, Other=3248033
    2013-02-27 10:17:38.66 spid72    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3267730
            InternalReservation=421 ExternalReservation=51 Min Free=256 Visible= 173968
    2013-02-27 10:17:38.66 spid72    Procedure Cache:  TotalProcs=1733 TotalPages=5511 InUsePages=2401
    2013-02-27 10:17:38.66 spid72    Dynamic Memory Manager:  Stolen=8141 OS Reserved=968
            OS Committed=946
            OS In Use=918
            Query Plan=6078 Optimizer=7
            General=2124
            Utilities=51 Connection=287
    2013-02-27 10:17:38.66 spid72    Global Memory Objects:  Resource=1427 Locks=143
            SQLCache=438 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=32
    2013-02-27 10:17:38.66 spid72    Query Memory Manager:  Grants=1 Waiting=0 Maximum=126387 Available=126280
    2013-02-27 11:05:16.93 logon     Login failed for user 'SELECTQUERY'.
    2013-02-27 11:05:17.16 logon     Login failed for user 'SELECTQUERY'.
    2013-02-27 11:14:04.84 spid70    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:14:05.13 spid70    Buffer Distribution:  Stolen=3026 Free=1330 Procedures=2190
            Inram=0 Dirty=31666 Kept=0
            I/O=31, Latched=233, Other=3238324
    2013-02-27 11:14:05.21 spid70    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270276
            InternalReservation=421 ExternalReservation=29059 Min Free=1024 Visible= 173968
    2013-02-27 11:14:05.21 spid70    Procedure Cache:  TotalProcs=302 TotalPages=2190 InUsePages=1371
    2013-02-27 11:14:05.21 spid70    Dynamic Memory Manager:  Stolen=4484 OS Reserved=1032
            OS Committed=1010
            OS In Use=1006
            Query Plan=2896 Optimizer=0
            General=1928
            Utilities=35 Connection=283
    2013-02-27 11:14:05.21 spid70    Global Memory Objects:  Resource=1429 Locks=100
            SQLCache=102 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:14:05.21 spid70    Query Memory Manager:  Grants=4 Waiting=0 Maximum=90186 Available=60562
    2013-02-27 11:15:10.73 spid91    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:15:10.87 spid91    Buffer Distribution:  Stolen=2468 Free=981 Procedures=1923
            Inram=0 Dirty=37044 Kept=0
            I/O=2014, Latched=232, Other=3232138
    2013-02-27 11:15:10.87 spid91    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3271413
            InternalReservation=417 ExternalReservation=26607 Min Free=1016 Visible= 173968
    2013-02-27 11:15:10.87 spid91    Procedure Cache:  TotalProcs=283 TotalPages=1923 InUsePages=1262
    2013-02-27 11:15:10.87 spid91    Dynamic Memory Manager:  Stolen=4227 OS Reserved=1032
            OS Committed=1010
            OS In Use=996
            Query Plan=2603 Optimizer=0
            General=1947
            Utilities=35 Connection=290
    2013-02-27 11:15:10.92 spid91    Global Memory Objects:  Resource=1430 Locks=119
            SQLCache=100 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:15:10.92 spid91    Query Memory Manager:  Grants=4 Waiting=0 Maximum=85084 Available=58299
    2013-02-27 11:15:12.57 spid79    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:15:12.67 spid79    Buffer Distribution:  Stolen=2900 Free=811 Procedures=1893
            Inram=0 Dirty=37652 Kept=0
            I/O=3016, Latched=230, Other=3230298
    2013-02-27 11:15:12.67 spid79    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3271354
            InternalReservation=416 ExternalReservation=26677 Min Free=1016 Visible= 173968
    2013-02-27 11:15:12.67 spid79    Procedure Cache:  TotalProcs=284 TotalPages=1893 InUsePages=1241
    2013-02-27 11:15:12.67 spid79    Dynamic Memory Manager:  Stolen=4496 OS Reserved=1032
            OS Committed=1010
            OS In Use=1005
            Query Plan=2664 Optimizer=146
            General=2009
            Utilities=42 Connection=292
    2013-02-27 11:15:12.67 spid79    Global Memory Objects:  Resource=1432 Locks=119
            SQLCache=100 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:15:12.67 spid79    Query Memory Manager:  Grants=4 Waiting=0 Maximum=85144 Available=58359
    2013-02-27 11:16:11.84 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:11.83 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:11.84 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:11.84 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:11.84 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:11.86 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:11.86 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:16:12.11 spid82    Buffer Distribution:  Stolen=2565 Free=1049 Procedures=2313
            Inram=0 Dirty=36390 Kept=0
    2013-02-27 11:16:12.12 spid82    Buffer Distribution:  Stolen=2614 Free=1031 Procedures=2314
    2013-02-27 11:16:12.11 spid82    Buffer Distribution:  Stolen=2528 Free=1045 Procedures=2314
            Inram=0 Dirty=36393 Kept=0
    2013-02-27 11:16:12.12 spid82    Buffer Distribution:  Stolen=2540 Free=1074 Procedures=2314
            Inram=0 Dirty=36390 Kept=0
            Inram=0 Dirty=36391 Kept=0
            I/O=1458, Latched=246, Other=3232777
            I/O=1458, Latched=243, Other=3232782
    2013-02-27 11:16:12.15 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270650
            InternalReservation=414 ExternalReservation=26578 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.15 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270650
            I/O=147, Latched=247, Other=3234126
            I/O=1586, Latched=245, Other=3232620
            InternalReservation=414 ExternalReservation=26578 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.15 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270650
            InternalReservation=414 ExternalReservation=26578 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.15 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270650
            InternalReservation=414 ExternalReservation=26578 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.15 spid82    Procedure Cache:  TotalProcs=299 TotalPages=2314 InUsePages=1453
    2013-02-27 11:16:12.15 spid82    Procedure Cache:  TotalProcs=300 TotalPages=2314 InUsePages=1453
    2013-02-27 11:16:12.15 spid82    Procedure Cache:  TotalProcs=301 TotalPages=2314 InUsePages=1453
    2013-02-27 11:16:12.15 spid82    Dynamic Memory Manager:  Stolen=4796 OS Reserved=1024
            OS Committed=1002
            OS In Use=992
            Query Plan=3146 Optimizer=0
            General=1952
    2013-02-27 11:16:12.15 spid82    Dynamic Memory Manager:  Stolen=4796 OS Reserved=1024
            OS Committed=1002
            OS In Use=992
            Utilities=63 Connection=279
    2013-02-27 11:16:12.15 spid82    Procedure Cache:  TotalProcs=300 TotalPages=2313 InUsePages=1453
            Query Plan=3146 Optimizer=0
            General=1952
            Utilities=63 Connection=279
    2013-02-27 11:16:12.15 spid82    Dynamic Memory Manager:  Stolen=4796 OS Reserved=1024
    2013-02-27 11:16:12.15 spid82    Dynamic Memory Manager:  Stolen=4796 OS Reserved=1024
            OS Committed=1002
            OS In Use=992
            Query Plan=3146 Optimizer=0
            General=1952
            Utilities=63 Connection=279
            OS Committed=1002
            OS In Use=992
            Query Plan=3146 Optimizer=0
            General=1952
            Utilities=63 Connection=279
    2013-02-27 11:16:12.15 spid82    Global Memory Objects:  Resource=1430 Locks=125
    2013-02-27 11:16:12.15 spid82    Global Memory Objects:  Resource=1430 Locks=125
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:16:12.15 spid82    Global Memory Objects:  Resource=1430 Locks=125
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
    2013-02-27 11:16:12.15 spid82    Global Memory Objects:  Resource=1430 Locks=125
    2013-02-27 11:16:12.15 spid82    Query Memory Manager:  Grants=5 Waiting=0 Maximum=85072 Available=58165
            Xact=33
            Xact=33
    2013-02-27 11:16:12.15 spid82    Query Memory Manager:  Grants=5 Waiting=0 Maximum=85072 Available=58165
    2013-02-27 11:16:12.15 spid82    Query Memory Manager:  Grants=5 Waiting=0 Maximum=85072 Available=58165
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:16:12.15 spid82    Query Memory Manager:  Grants=5 Waiting=0 Maximum=85072 Available=58165
    2013-02-27 11:16:12.20 spid82    Buffer Distribution:  Stolen=2888 Free=1149 Procedures=2146
            Inram=0 Dirty=36405 Kept=0
            I/O=1907, Latched=250, Other=3232055
    2013-02-27 11:16:12.20 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270600
            InternalReservation=414 ExternalReservation=26588 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.20 spid82    Procedure Cache:  TotalProcs=298 TotalPages=2146 InUsePages=1377
    2013-02-27 11:16:12.20 spid82    Dynamic Memory Manager:  Stolen=4701 OS Reserved=1008
            OS Committed=986
            OS In Use=963
            Query Plan=3008 Optimizer=3
            General=1962
            Utilities=63 Connection=280
    2013-02-27 11:16:12.20 spid82    Global Memory Objects:  Resource=1430 Locks=125
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:16:12.20 spid82    Query Memory Manager:  Grants=5 Waiting=0 Maximum=85072 Available=58165
    2013-02-27 11:16:12.20 spid82    Buffer Distribution:  Stolen=2666 Free=1146 Procedures=2147
            Inram=0 Dirty=36390 Kept=0
            I/O=1586, Latched=248, Other=3232617
    2013-02-27 11:16:12.20 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270611
            InternalReservation=414 ExternalReservation=26588 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.20 spid82    Procedure Cache:  TotalProcs=301 TotalPages=2147 InUsePages=1377
    2013-02-27 11:16:12.20 spid82    Dynamic Memory Manager:  Stolen=4701 OS Reserved=1008
            OS Committed=986
            OS In Use=963
            Query Plan=3008 Optimizer=3
            General=1962
            Utilities=63 Connection=280
    2013-02-27 11:16:12.20 spid82    Global Memory Objects:  Resource=1430 Locks=125
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:16:12.20 spid82    Query Memory Manager:  Grants=5 Waiting=0 Maximum=85072 Available=58165
    2013-02-27 11:16:12.87 spid82    Buffer Distribution:  Stolen=3305 Free=793 Procedures=2246
            Inram=0 Dirty=36428 Kept=0
            I/O=4241, Latched=260, Other=3229527
    2013-02-27 11:16:12.87 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3271078
            InternalReservation=432 ExternalReservation=26749 Min Free=1024 Visible= 173968
    2013-02-27 11:16:12.87 spid82    Procedure Cache:  TotalProcs=290 TotalPages=2246 InUsePages=1449
    2013-02-27 11:16:12.87 spid82    Dynamic Memory Manager:  Stolen=4633 OS Reserved=1008
            OS Committed=986
            OS In Use=968
            Query Plan=3082 Optimizer=0
            General=1829
            Utilities=64 Connection=278
    2013-02-27 11:16:12.87 spid82    Global Memory Objects:  Resource=1428 Locks=125
            SQLCache=94 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:16:12.87 spid82    Query Memory Manager:  Grants=6 Waiting=0 Maximum=85061 Available=58015
    2013-02-27 11:17:36.86 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:17:37.19 spid82    Buffer Distribution:  Stolen=2643 Free=1014 Procedures=2163
            Inram=0 Dirty=28655 Kept=0
            I/O=2148, Latched=229, Other=3239948
    2013-02-27 11:17:37.19 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3271149
            InternalReservation=444 ExternalReservation=26021 Min Free=1024 Visible= 173968
    2013-02-27 11:17:37.19 spid82    Procedure Cache:  TotalProcs=269 TotalPages=2163 InUsePages=1418
    2013-02-27 11:17:37.19 spid82    Dynamic Memory Manager:  Stolen=4393 OS Reserved=1032
            OS Committed=1010
            OS In Use=1008
            Query Plan=2847 Optimizer=0
            General=1853
            Utilities=80 Connection=273
    2013-02-27 11:17:37.20 spid82    Global Memory Objects:  Resource=1429 Locks=124
            SQLCache=86 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:17:37.20 spid82    Query Memory Manager:  Grants=4 Waiting=0 Maximum=94152 Available=67887
    2013-02-27 11:17:37.64 spid57    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:17:37.75 spid57    Buffer Distribution:  Stolen=2571 Free=956 Procedures=2090
            Inram=0 Dirty=28651 Kept=0
            I/O=2341, Latched=228, Other=3239963
    2013-02-27 11:17:37.75 spid57    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3271211
            InternalReservation=444 ExternalReservation=26021 Min Free=1024 Visible= 173968
    2013-02-27 11:17:37.75 spid57    Procedure Cache:  TotalProcs=265 TotalPages=2090 InUsePages=1418
    2013-02-27 11:17:37.75 spid57    Dynamic Memory Manager:  Stolen=4389 OS Reserved=1032
            OS Committed=1010
            OS In Use=1008
            Query Plan=2844 Optimizer=0
            General=1853
            Utilities=80 Connection=272
    2013-02-27 11:17:37.75 spid57    Global Memory Objects:  Resource=1429 Locks=124
            SQLCache=86 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:17:37.75 spid57    Query Memory Manager:  Grants=4 Waiting=0 Maximum=94152 Available=67887
    2013-02-27 11:19:34.18 spid82    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:19:34.36 spid82    Buffer Distribution:  Stolen=2952 Free=1376 Procedures=2285
            Inram=0 Dirty=31144 Kept=0
            I/O=801, Latched=237, Other=3238005
    2013-02-27 11:19:34.36 spid82    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270193
            InternalReservation=412 ExternalReservation=10944 Min Free=1024 Visible= 173968
    2013-02-27 11:19:34.36 spid82    Procedure Cache:  TotalProcs=276 TotalPages=2285 InUsePages=1389
    2013-02-27 11:19:34.36 spid82    Dynamic Memory Manager:  Stolen=4963 OS Reserved=1048
            OS Committed=1026
            OS In Use=1015
            Query Plan=2968 Optimizer=0
            General=2308
            Utilities=80 Connection=274
    2013-02-27 11:19:34.36 spid82    Global Memory Objects:  Resource=1430 Locks=120
            SQLCache=90 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:19:34.36 spid82    Query Memory Manager:  Grants=4 Waiting=0 Maximum=118472 Available=107260
    2013-02-27 11:21:36.93 spid79    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:21:36.98 spid91    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 11:21:37.04 spid79    Buffer Distribution:  Stolen=2420 Free=1168 Procedures=2359
            Inram=0 Dirty=59668 Kept=0
            I/O=106, Latched=229, Other=3210850
    2013-02-27 11:21:37.04 spid79    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270869
            InternalReservation=421 ExternalReservation=4126 Min Free=984 Visible= 173968
    2013-02-27 11:21:37.04 spid79    Procedure Cache:  TotalProcs=311 TotalPages=2359 InUsePages=1520
    2013-02-27 11:21:37.04 spid79    Dynamic Memory Manager:  Stolen=4566 OS Reserved=1040
            OS Committed=1018
            OS In Use=984
            Query Plan=3013 Optimizer=0
            General=1860
            Utilities=62 Connection=267
    2013-02-27 11:21:37.04 spid79    Global Memory Objects:  Resource=1430 Locks=195
            SQLCache=91 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:21:37.04 spid79    Query Memory Manager:  Grants=3 Waiting=0 Maximum=127656 Available=123332
    2013-02-27 11:21:37.12 spid91    Buffer Distribution:  Stolen=2326 Free=1265 Procedures=2359
            Inram=0 Dirty=59745 Kept=0
            I/O=106, Latched=229, Other=3210770
    2013-02-27 11:21:37.12 spid91    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3270888
            InternalReservation=421 ExternalReservation=4214 Min Free=984 Visible= 173968
    2013-02-27 11:21:37.12 spid91    Procedure Cache:  TotalProcs=311 TotalPages=2359 InUsePages=1520
    2013-02-27 11:21:37.12 spid91    Dynamic Memory Manager:  Stolen=4537 OS Reserved=1040
            OS Committed=1018
            OS In Use=984
            Query Plan=3009 Optimizer=0
            General=1860
            Utilities=36 Connection=268
    2013-02-27 11:21:37.12 spid91    Global Memory Objects:  Resource=1430 Locks=195
            SQLCache=91 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=33
    2013-02-27 11:21:37.12 spid91    Query Memory Manager:  Grants=3 Waiting=0 Maximum=127656 Available=123332
    2013-02-27 11:52:11.32 spid76    Autogrow of file 'templog' in database 'tempdb' took 61875 milliseconds.  Consider using

    ALTER DATABASE to set a smaller FILEGROWTH for this file.
    2013-02-27 11:55:58.81 spid76    Autogrow of file 'templog' in database 'tempdb' took 60750 milliseconds.  Consider using

    ALTER DATABASE to set a smaller FILEGROWTH for this file.
    2013-02-27 11:57:40.23 spid76    Autogrow of file 'templog' in database 'tempdb' took 62609 milliseconds.  Consider using

    ALTER DATABASE to set a smaller FILEGROWTH for this file.
    2013-02-27 11:59:17.26 spid76    Autogrow of file 'templog' in database 'tempdb' took 61360 milliseconds.  Consider using

    ALTER DATABASE to set a smaller FILEGROWTH for this file.
    2013-02-27 12:03:10.60 spid76    Autogrow of file 'templog' in database 'tempdb' took 101703 milliseconds.  Consider using

    ALTER DATABASE to set a smaller FILEGROWTH for this file.

    2013-02-27 12:11:13.77 spid71    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:11:14.83 spid71    Buffer Distribution:  Stolen=3681 Free=1246 Procedures=2327
            Inram=0 Dirty=64021 Kept=0
            I/O=1979, Latched=224, Other=3203322
    2013-02-27 12:11:14.83 spid71    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3269421
            InternalReservation=413 ExternalReservation=3321 Min Free=984 Visible= 173968
    2013-02-27 12:11:14.83 spid71    Procedure Cache:  TotalProcs=479 TotalPages=2327 InUsePages=1014
    2013-02-27 12:11:14.83 spid71    Dynamic Memory Manager:  Stolen=5864 OS Reserved=1040
            OS Committed=1018
            OS In Use=986
            Query Plan=3323 Optimizer=0
            General=2098
            Utilities=339 Connection=282
    2013-02-27 12:11:14.85 spid71    Global Memory Objects:  Resource=1430 Locks=810
            SQLCache=97 Replication=2
            LockBytes=2 ServerGlobal=35
            Xact=34
    2013-02-27 12:11:14.85 spid71    Query Memory Manager:  Grants=2 Waiting=0 Maximum=95621 Available=92031
    2013-02-27 12:32:25.99 spid89    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:32:26.04 spid89    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:32:26.04 spid89    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:32:26.05 spid89    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:32:26.21 spid89    Buffer Distribution:  Stolen=2761 Free=918 Procedures=4803
            Inram=0 Dirty=196325 Kept=0
            I/O=3, Latched=218, Other=3071772
    2013-02-27 12:32:26.21 spid89    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3268341
            InternalReservation=410 ExternalReservation=609 Min Free=592 Visible= 173968
    2013-02-27 12:32:26.21 spid89    Procedure Cache:  TotalProcs=1165 TotalPages=4803 InUsePages=2067
    2013-02-27 12:32:26.21 spid89    Dynamic Memory Manager:  Stolen=7110 OS Reserved=1048
            OS Committed=1026
            OS In Use=1023
            Query Plan=4689 Optimizer=0
            General=2044
            Utilities=323 Connection=269
    2013-02-27 12:32:26.21 spid89    Global Memory Objects:  Resource=1433 Locks=713
            SQLCache=137 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=34
    2013-02-27 12:32:26.21 spid89    Query Memory Manager:  Grants=1 Waiting=0 Maximum=127389 Available=126349
    2013-02-27 12:32:26.21 spid89    Buffer Distribution:  Stolen=2985 Free=916 Procedures=4567
            Inram=0 Dirty=196345 Kept=0
            I/O=2, Latched=217, Other=3071768
    2013-02-27 12:32:26.21 spid89    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3268341
            InternalReservation=410 ExternalReservation=609 Min Free=592 Visible= 173968
    2013-02-27 12:32:26.21 spid89    Procedure Cache:  TotalProcs=1165 TotalPages=4567 InUsePages=2067
    2013-02-27 12:32:26.21 spid89    Dynamic Memory Manager:  Stolen=7114 OS Reserved=1048
            OS Committed=1026
            OS In Use=1023
            Query Plan=4693 Optimizer=0
            General=2044
            Utilities=323 Connection=269
    2013-02-27 12:32:26.21 spid89    Global Memory Objects:  Resource=1433 Locks=713
            SQLCache=137 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=34
    2013-02-27 12:32:26.21 spid89    Query Memory Manager:  Grants=1 Waiting=0 Maximum=127389 Available=126349
    2013-02-27 12:32:26.21 spid89    Buffer Distribution:  Stolen=3050 Free=914 Procedures=4514
            Inram=0 Dirty=196334 Kept=0
            I/O=0, Latched=217, Other=3071771
    2013-02-27 12:32:26.21 spid89    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3268341
            InternalReservation=410 ExternalReservation=609 Min Free=592 Visible= 173968
    2013-02-27 12:32:26.21 spid89    Procedure Cache:  TotalProcs=1165 TotalPages=4514 InUsePages=2067
    2013-02-27 12:32:26.21 spid89    Dynamic Memory Manager:  Stolen=7114 OS Reserved=1048
            OS Committed=1026
            OS In Use=1023
            Query Plan=4693 Optimizer=0
            General=2044
            Utilities=323 Connection=269
    2013-02-27 12:32:26.21 spid89    Global Memory Objects:  Resource=1433 Locks=713
            SQLCache=137 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=34
    2013-02-27 12:32:26.21 spid89    Query Memory Manager:  Grants=1 Waiting=0 Maximum=127389 Available=126349
    2013-02-27 12:32:26.24 spid89    Buffer Distribution:  Stolen=3021 Free=1080 Procedures=4381
            Inram=0 Dirty=196326 Kept=0
            I/O=4, Latched=219, Other=3071769
    2013-02-27 12:32:26.24 spid89    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3268352
            InternalReservation=403 ExternalReservation=695 Min Free=592 Visible= 173968
    2013-02-27 12:32:26.29 spid89    Procedure Cache:  TotalProcs=1160 TotalPages=4381 InUsePages=2015
    2013-02-27 12:32:26.29 spid89    Dynamic Memory Manager:  Stolen=6898 OS Reserved=1024
            OS Committed=1002
            OS In Use=952
            Query Plan=4473 Optimizer=0
            General=1978
            Utilities=323 Connection=268
    2013-02-27 12:32:26.29 spid89    Global Memory Objects:  Resource=1431 Locks=713
            SQLCache=137 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=34
    2013-02-27 12:32:26.29 spid89    Query Memory Manager:  Grants=1 Waiting=0 Maximum=127389 Available=126349
    2013-02-27 12:34:27.54 spid62    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:34:27.62 spid62    Buffer Distribution:  Stolen=2902 Free=750 Procedures=4747
            Inram=0 Dirty=210790 Kept=0
            I/O=0, Latched=207, Other=3057404
    2013-02-27 12:34:27.62 spid62    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3268384
            InternalReservation=405 ExternalReservation=524 Min Free=456 Visible= 173968
    2013-02-27 12:34:27.62 spid62    Procedure Cache:  TotalProcs=1213 TotalPages=4747 InUsePages=2047
    2013-02-27 12:34:27.62 spid62    Dynamic Memory Manager:  Stolen=7150 OS Reserved=1024
            OS Committed=1002
            OS In Use=996
            Query Plan=4624 Optimizer=0
            General=2132
            Utilities=324 Connection=258
    2013-02-27 12:34:27.62 spid62    Global Memory Objects:  Resource=1434 Locks=717
            SQLCache=141 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=34
    2013-02-27 12:34:27.62 spid62    Query Memory Manager:  Grants=1 Waiting=0 Maximum=127360 Available=126320
    2013-02-27 12:35:28.79 spid60    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    2013-02-27 12:35:28.87 spid60    Buffer Distribution:  Stolen=2843 Free=830 Procedures=4984
            Inram=0 Dirty=215685 Kept=0
            I/O=2, Latched=211, Other=3052245
    2013-02-27 12:35:28.87 spid60    Buffer Counts:  Commited=3276800 Target=3276800 Hashed=3268153
            InternalReservation=393 ExternalReservation=550 Min Free=496 Visible= 173968
    2013-02-27 12:35:28.87 spid60    Procedure Cache:  TotalProcs=1306 TotalPages=4984 InUsePages=2144
    2013-02-27 12:35:28.87 spid60    Dynamic Memory Manager:  Stolen=7327 OS Reserved=1024
            OS Committed=1002
            OS In Use=997
            Query Plan=4832 Optimizer=0
            General=2102
            Utilities=323 Connection=259
    2013-02-27 12:35:28.87 spid60    Global Memory Objects:  Resource=1434 Locks=714
            SQLCache=146 Replication=2
            LockBytes=2 ServerGlobal=34
            Xact=34
    2013-02-27 12:35:28.87 spid60    Query Memory Manager:  Grants=1 Waiting=0 Maximum=127209 Available=126169
     

All Replies