Post reply

sp_helpdistpublisher @check_user = 1

  • September 28, 2005 at 4:20 am

    #91335

    Hi,

    We have a SQL 2000 server that we have recently undertaken support of. This is not setup as a distributor or a publisher. It is not involved in replication. Yet there are a number of connections (100+ on some days) on the master database from user NT AUTHORITY/SYSTEM application SQLDMO_xxx executing

    exec sp_helpdistpublisher @check_user = 1.

    Why would it be doing that, when the server is not setup for replication? The majority of these connections are taking up ZERO disk I/O and CPU time and are running at 25 and 55 mins past the hour, every hour.

    Reporting Services is installed on this server.

    Appreciate your help.

    Thanks, Siz

  • September 28, 2005 at 6:51 am

    #593633

    It looks like Reporting Services is using SQL-DMO to pull reports.  I would look at whatever application(s) that are set-up using RS and see when they run (possibly at 5 till the bottom/top of the hour)....

    I would also contact the DEV team that wrote the RS reports in .NET and find out what they are doing ....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply