Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Australia
    Posts
    2

    Unanswered: Perlib registry corruptions and MSDE

    I support many uncontrolled MSDE installs on Win98 machines who are moving to XP. Unfortunately, many of the machine owners are choosing to upgrade their machines to XP, rather than choosing to re-roll.

    The problem with this is that the edition of MSDE 2 (SP2) that I'm supporting not only gets it's registry items for the services ripped out, but the perflib registry itself becomes truncated by the MS Windows upgrade. So, no services and the thing can't be uninstalled due to performance monitor rollback issues...

    Refer you all to MS KB Article 300956 and the fix for the broken registry which includes expanding system files that contain the default perflib entries referenced by registry. I ran through this process and found that it worked. I was then able to install a named instance of MSDE and remove the broken copy, followed by the instance. From here an install of MSDE went on fine. So what am I posting for?

    Adding performance counters into the perflib/009 registry key during the install (which is a condition of my MSDE install and can't be changed) is all well and good, but what about other applications requiring performance counters? Since they have been replaced by the system default performance monitors what kinds of other services, apps or anything may be adversly affected? Not really a db question but directly linked to being able to support MSDE...
    Is there anyone out there who's had to utilise this fix before and are there any repercussions that are considered unnaceptable in terms of losing machine functionality???

    Basically I need to know if taking performance counters back to the stock system settings is not all that horrible a thing to do to XP client machines, especially as the perflib keys are so corrupted anyway.

    ANY THOUGHTS???

    (other than formatting and starting again of course!)

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Upgrade OS to higher version will always have these kind of issues, and you can know the status of those application by running or check for compatibility.

    As the KBA referred resolve the issue for PERFMON counters, have a look at Technet for further references.


    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    Australia
    Posts
    2
    Cheers - the problem is that we have no control on the users upgrading their OS's. I'll have a look at technet and see if theres anything I can pick up on performance monitors and there reinstallation.

    Thanks again.

    If anyone has anything else on the subject...

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://www.dbazine.com/cook7.html - useful article about MSDE.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •