SQL Server Performance

Know anything about this error? 17827 - ...failure while attempting to encrypt a password

Discussion in 'SQL Server 2005 General DBA Questions' started by DBADave, Jun 19, 2008.

  1. DBADave New Member

    In the middle of the night we received the following error on one of our 64bit 2005 servers; probably from a batch process.
    Error: 17827, Severity: 20, State: 1.
    There was a failure while attempting to encrypt a password. The connection has been closed.
    Any idea what this means. I found little while doing a Google search.
    Thanks, Dave
  2. techbabu303 New Member

    SQL edition and SP you have installed ?
    -Sat
  3. DBADave New Member

    Enterprise Edition with SP2
  4. techbabu303 New Member

    One of our customer saw this after installing SP2 , did it happen to you by any chance ?
    This message is listed in MSDN site in list of error number but no clue on resolution as you are aware.
    Some more digging required hang in there Dave.
    Cheers
    Sat
  5. DBADave New Member

    Sorry for the delay in my response. I just got back from vacation. Now I have to filter through 1,900+ emails after one week (about 1/2 MOM and SQL alerts).
    SP2 has been on the server since it was initially configured. The error has not returned, but I am still puzzled as to why it happened and what it means.
    Thanks, Dave
  6. techbabu303 New Member

    No information yet from regional MVP here, Satya any ideas ?
    -Sat
  7. satya Moderator

    I'm back guys, it has been hectic during June .. .my gig at Tech-ed and coming work busy for 2 weeks..
    Anyway coming to the problem, Dave, can you check how many user connections during this error is generated and also find out what kind of processes are running. Running DBCC MEMORYSTATUS is good to get how memory is handling.
  8. techbabu303 New Member

    That explains your sudden dissappearance, cool to have you back.
    -SatN
  9. satya Moderator

    Thanks Guys.
    Speaking at Tech-ed has been a good experience, not to mention about learning from other PRofessionals too. My dream come true....
    Hmm, the problem seems to be peculiar to me and the server is shared between the instances it may be obvious that this instnace might be suffering from the memory pressure while processing that batch job (what you referred earlier). Still I think there is a slight chance of reoccuring the same problem and may not be at the same point of time, better to watch and capture the system information with sQLDIAG for further assesment.
    I presume you may have the support contract with MS CSS, if so better to knock their door for further assesment, before anything serious appears.
  10. techbabu303 New Member

    Hey Dave,
    Any solution , anything from MS which can helps us ?
    -Sat
  11. DBADave New Member

    Nothing yet. We decided to take a "wait and see" approach. If it happens a second time we will contact MS, but so far there has been no reoccurance. We ended up diverting resources to troubleshoot cluster errors 1122 and 1123, which a MS doc said was nothing to worry about, but we suddenly received a large number. Turned out to be somehow related to QOS being turned on at the network level. CISCO is still not sure why it produced the cluster and MOM errors, but we shut it off and all is well. But that's another topic for another post. :)
    I will keep you posted if 17827 pops up again.
    Thanks, Dave
  12. Mahendra_9@9 New Member

    Hi Satya ,
    We have observed this error 2 times in last 3 days , Could you please let me know the probable reasons for this error.
    SQL Server 2005 32 bit SP2
    Windows server 2003 SP2
    Thanks,
    Mahendra.
  13. satya Moderator

    Mahendra
    Welcome to the forums.
    I believe from the above post Dave hasn't posted anything since July that can assumed that issue might have been suppressed.
    Coming to your issues, is the same error message popped up at your end?
    If so, are you using database encryption?
  14. DBADave New Member

    The error never returned for us so we did not pursue the matter.
    Dave
  15. DBADave New Member

    Hi Satya. How did Tech-Ed go?
    There were 293 connections approximately one minute before the error occurred. I don't see any problems in MEMORYSTATUS output, but perhaps I am missing something. The server is 64-bit with 32GB of memory. It is a combined Test and Development server running three instances of SQL Server. One instance has a max memory of 18GB, the second is 5GB and the third is 5GB. That leaves 4GB for the OS. Since this is 64bit isn't the AWE info reported by MEMORYSTATUS meaningless?Memory Manager KB
    ------------------------------ --------------------
    VM Reserved 33824368
    VM Committed 250024
    AWE Allocated 19177016
    Reserved Memory 1024
    Reserved Memory In Use 0
    (5 row(s) affected)
    Memory node Id = 0 KB
    ------------------------------ --------------------
    VM Reserved 33818608
    VM Committed 244352
    AWE Allocated 19177016
    MultiPage Allocator 83832
    SinglePage Allocator 4070816
    (5 row(s) affected)
    MEMORYCLERK_SQLGENERAL (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 95328
    MultiPage Allocator 5176
    (7 row(s) affected)
    MEMORYCLERK_SQLBUFFERPOOL (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 33603584
    VM Committed 32768
    AWE Allocated 19177016
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 0
    MultiPage Allocator 1288
    (7 row(s) affected)
    MEMORYCLERK_SQLQUERYEXEC (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 1344
    MultiPage Allocator 416
    (7 row(s) affected)
    MEMORYCLERK_SQLOPTIMIZER (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 1464
    MultiPage Allocator 112
    (7 row(s) affected)
    MEMORYCLERK_SQLUTILITIES (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 240
    VM Committed 240
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 3120
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_SQLSTORENG (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 12608
    VM Committed 12608
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8240
    MultiPage Allocator 13312
    (7 row(s) affected)
    MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 4560
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_SQLCLR (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_SQLSERVICEBROKER (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 120
    MultiPage Allocator 320
    (7 row(s) affected)
    MEMORYCLERK_SQLHTTP (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_SNI (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 376
    MultiPage Allocator 16
    (7 row(s) affected)
    MEMORYCLERK_FULLTEXT (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 16
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_SQLXP (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 16
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_BHF (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 2352
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_SQLQERESERVATIONS (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 17792
    MultiPage Allocator 0
    (7 row(s) affected)
    MEMORYCLERK_HOST (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 136
    MultiPage Allocator 64
    (7 row(s) affected)
    MEMORYCLERK_SOSNODE (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 42008
    MultiPage Allocator 50584
    (7 row(s) affected)
    MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 48
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_OBJCP (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 328944
    MultiPage Allocator 6104
    (7 row(s) affected)
    CACHESTORE_SQLCP (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 3475312
    MultiPage Allocator 5576
    (7 row(s) affected)
    CACHESTORE_PHDR (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 35856
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_XPROC (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 88
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_TEMPTABLES (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 120
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_NOTIF (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 16
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_VIEWDEFINITIONS (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 16
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_XMLDBTYPE (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_XMLDBELEMENT (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_XMLDBATTRIBUTE (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_STACKFRAMES (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 0
    MultiPage Allocator 8
    (7 row(s) affected)
    CACHESTORE_BROKERTBLACS (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 96
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_BROKERKEK (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_BROKERDSH (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_BROKERUSERCERTLOOKUP (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_BROKERRSB (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_BROKERREADONLY (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 32
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_BROKERTO (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 8
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_EVENTS (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 16
    MultiPage Allocator 0
    (7 row(s) affected)
    CACHESTORE_SYSTEMROWSET (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 4792
    MultiPage Allocator 0
    (7 row(s) affected)
    USERSTORE_SCHEMAMGR (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 23840
    MultiPage Allocator 80
    (7 row(s) affected)
    USERSTORE_DBMETADATA (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 28864
    MultiPage Allocator 0
    (7 row(s) affected)
    USERSTORE_TOKENPERM (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 1792
    MultiPage Allocator 0
    (7 row(s) affected)
    USERSTORE_OBJPERM (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 568
    MultiPage Allocator 0
    (7 row(s) affected)
    USERSTORE_SXC (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 3528
    MultiPage Allocator 16
    (7 row(s) affected)
    OBJECTSTORE_LBSS (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 128
    MultiPage Allocator 528
    (7 row(s) affected)
    OBJECTSTORE_SNI_PACKET (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 6520
    MultiPage Allocator 48
    (7 row(s) affected)
    OBJECTSTORE_SERVICE_BROKER (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 0
    VM Committed 0
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 272
    MultiPage Allocator 0
    (7 row(s) affected)
    OBJECTSTORE_LOCK_MANAGER (Total) KB
    ---------------------------------------------------------------- --------------------
    VM Reserved 65536
    VM Committed 65536
    AWE Allocated 0
    SM Reserved 0
    SM Commited 0
    SinglePage Allocator 33480
    MultiPage Allocator 0
    (7 row(s) affected)
    Buffer Distribution Buffers
    ------------------------------ -----------
    Stolen 16950
    Free 1331977
    Cached 491934
    Database (clean) 505411
    Database (dirty) 13006
    I/O 0
    Latched 18
    (7 row(s) affected)
    Buffer Counts Buffers
    ------------------------------ --------------------
    Committed 2359296
    Target 2359296
    Hashed 518436
    Stolen Potential 1730256
    External Reservation 2224
    Min Free 256
    Visible 2359296
    Available Paging File 390080
    (8 row(s) affected)
    Procedure Cache Value
    ------------------------------ -----------
    TotalProcs 23038
    TotalPages 481489
    InUsePages 5586
    (3 row(s) affected)
    Global Memory Objects Buffers
    ------------------------------ --------------------
    Resource 679
    Locks 4188
    XDES 138
    SETLS 8
    SE Dataset Allocators 16
    SubpDesc Allocators 16
    SE SchemaManager 2989
    SQLCache 11395
    Replication 2
    ServerGlobal 48
    XP Global 2
    SortTables 1524
    (12 row(s) affected)
    Query Memory Objects Value
    ------------------------------ -----------
    Grants 2
    Waiting 0
    Available (Buffers) 1609311
    Maximum (Buffers) 1611535
    Limit 1611535
    Next Request 0
    Waiting For 0
    Cost 0
    Timeout 0
    Wait Time 0
    Last Target 1624335
    (11 row(s) affected)
    Small Query Memory Objects Value
    ------------------------------ -----------
    Grants 0
    Waiting 0
    Available (Buffers) 12800
    Maximum (Buffers) 12800
    Limit 12800
    (5 row(s) affected)
    Optimization Queue Value
    ------------------------------ --------------------
    Overall Memory 15491948544
    Target Memory 10726227968
    Last Notification 1
    Timeout 6
    Early Termination Factor 5
    (5 row(s) affected)
    Small Gateway Value
    ------------------------------ --------------------
    Configured Units 32
    Available Units 32
    Acquires 0
    Waiters 0
    Threshold Factor 380000
    Threshold 380000
    (6 row(s) affected)
    Medium Gateway Value
    ------------------------------ --------------------
    Configured Units 8
    Available Units 8
    Acquires 0
    Waiters 0
    Threshold Factor 12
    (5 row(s) affected)
    Big Gateway Value
    ------------------------------ --------------------
    Configured Units 1
    Available Units 1
    Acquires 0
    Waiters 0
    Threshold Factor 8
    (5 row(s) affected)
    MEMORYBROKER_FOR_CACHE Value
    -------------------------------- --------------------
    Allocations 491935
    Rate 15
    Target Allocations 1784552
    Future Allocations 0
    Last Notification 1
    (5 row(s) affected)
    MEMORYBROKER_FOR_STEAL Value
    -------------------------------- --------------------
    Allocations 16713
    Rate 39
    Target Allocations 1309354
    Future Allocations 0
    Last Notification 1
    (5 row(s) affected)
    MEMORYBROKER_FOR_RESERVE Value
    -------------------------------- --------------------
    Allocations 1112
    Rate 0
    Target Allocations 1732629
    Future Allocations 440027
    Last Notification 1
    (5 row(s) affected)

Share This Page