Post reply

SqlQueryNotificationStoredProcedure

  • October 27, 2016 at 1:49 am

    #314436

    Saw multiple stored procedures with names starting like below

    SqlQueryNotificationStoredProcedure-

    can anyone help me understand why ? Read that this occurs as part of notification, was wondering why this comes in a different schema other than dbo. and is it because of database mail. We are using SignalR but have a different database for that.

  • October 27, 2016 at 5:08 am

    #1909081

    Can anyone help me on this Please

  • October 27, 2016 at 11:16 am

    #1909193

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

  • October 31, 2016 at 4:09 am

    #1909565

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

  • October 31, 2016 at 5:32 am

    #1909577

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Just because it was created a year ago, doesn't mean it isn't used.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 31, 2016 at 5:50 am

    #1909580

    Thom A (10/31/2016)

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Just because it was created a year ago, doesn't mean it isn't used.

    Agreed. I (and most others, I'd imagine) have lots of things over 1 year old that are still in use.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 31, 2016 at 6:55 am

    #1909593

    Ed Wagner (10/31/2016)

    Thom A (10/31/2016)

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Just because it was created a year ago, doesn't mean it isn't used.

    Agreed. I (and most others, I'd imagine) have lots of things over 1 year old that are still in use.

    I asked this because as per my understanding these procedures are not supposed to stay in DB for a long time. Please correct me if i am wrong.

  • October 31, 2016 at 7:04 am

    #1909596

    Rechana Rajan (10/31/2016)

    Ed Wagner (10/31/2016)

    Thom A (10/31/2016)

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Just because it was created a year ago, doesn't mean it isn't used.

    Agreed. I (and most others, I'd imagine) have lots of things over 1 year old that are still in use.

    I asked this because as per my understanding these procedures are not supposed to stay in DB for a long time. Please correct me if i am wrong.

    Unless it was created by an individual trying to be clever.

    create procedure [SqlQueryNotificationStoredProcedure-Test]

    as

    begin

    select GETDATE();

    end;

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 31, 2016 at 1:10 pm

    #1909728

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Typically they won't stay around that long but it doesn't necessarily mean they aren't in use. And on the other hand, the stop method for SQL Dependency objects doesn't always work too well. Do you know of apps using Broker Services against the database? Do you have any queues associated with the stored procedures (check the GUIDs appended to the names of the stored procedures and queues)?

    select *

    from sys.service_queues

    Do you have receives occurring for the queues?

    select *

    from sys.dm_broker_queue_monitors

    You'd probably want to do some poking around and check with the application group to see if these are active.

    Sue

  • November 1, 2016 at 12:58 am

    #1909786

    Sue_H (10/31/2016)

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Typically they won't stay around that long but it doesn't necessarily mean they aren't in use. And on the other hand, the stop method for SQL Dependency objects doesn't always work too well. Do you know of apps using Broker Services against the database? Do you have any queues associated with the stored procedures (check the GUIDs appended to the names of the stored procedures and queues)?

    select *

    from sys.service_queues

    Do you have receives occurring for the queues?

    select *

    from sys.dm_broker_queue_monitors

    You'd probably want to do some poking around and check with the application group to see if these are active.

    Sue

    Thanks Sue

Viewing 10 posts - 1 through 9 (of 9 total)

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