Performance condition alert definition drop down not populating

Posted on 2008-11-11
Last Modified: 2012-05-05
In 2005 alerts, when attempting to define a performance condition alert, the object drop down does not populate--it's just blank. It should populate with all sorts of objects. I have sysadmin role and it has SP2. Thanks.
Question by:barnesco
    LVL 15

    Expert Comment

    Is it 32 or 64 bit?
    LVL 7

    Expert Comment

    What do you get when you query the following dynamic view:
       select * from sys.dm_os_performance_counters

    I wonder if the performance counters were installed correctly,

    Is this a named instance or a default instance?  All of my default instance database (32bit or 64bit) work fine.  My named instance DB had issues with missing performance counters.

    The following URL helped me figure out what was going on.  I had to unload and reload the perf counters.  Then I stopped and started the instance.

    Author Comment

    32 bit. And it's a default instance. When I run the query above, nothing is returned.

    Author Comment

    lunknak...could you please send the url? Thanks.
    LVL 7

    Accepted Solution


    Author Comment

    Sorry for the late reply. It hasn't been top priority for my client. I'll need to apply it, but the link looks good and I think it's a great start to solving the problem. Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now