Monday, March 26, 2012

Login failed for user (null)... Failure to reserve contiguous memory

Symptom:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se
rve
2004-03-04 19:46:07.40 spid125 WARNING: Failed to reserve contiguous memor
y of Size= 65536.
2004-03-04 19:46:07.42 spid125 Query Memory Manager: Grants=0 Waiting=0 Ma
ximum=23010 Available=23010
2004-03-04 19:46:07.42 spid125 Global Memory Objects: Resource=1702 Locks=
76 ...
2004-03-04 19:46:07.42 spid125 Dynamic Memory Manager: Stolen=191349 OS Re
served=40424 ...
2004-03-04 19:46:07.42 spid125 Procedure Cache: TotalProcs=9843 TotalPages
=15049 InUsePages=2369
2004-03-04 19:46:07.42 spid125 Buffer Counts: Commited=208704 Target=20870
4 Hashed=17343...
2004-03-04 19:46:07.42 spid125 Buffer Distribution: Stolen=176300 Free=12
Procedures=15049...Larry, you may want to look at Microsoft KB article 818095. The symptoms you
have listed are very close to what is described in that article. The good n
ews for you is that Microsoft has a fix if the symptoms match.

No comments:

Post a Comment