Log size increasing

10 views
Skip to first unread message

sunil kumar

unread,
Jul 22, 2016, 6:18:23 AM7/22/16
to nginn-messagebus
Hi,
Though the application is not running below queries are firing by the nginn which i making the log of the sql database to huge.

update top (1000) "QueueName" with(READPAST) set subqueue='I' where subqueue='R' and retry_time <= getdate()

update top (1000) "QueueName"with(READPAST) set subqueue='I' where subqueue='R' and retry_time <= getdate()

update top (1000) "QueueName"with(READPAST) set subqueue='I' where subqueue='R' and retry_time <= getdate()


Is there any way to restrict this if my application is not running

rafal.gwizdala

unread,
Jul 22, 2016, 7:36:17 AM7/22/16
to k.sunil...@gmail.com, nginn-me...@googlegroups.com
change nlog configuration to skip these entries
rg



Wysłano z telefonu Xiaomi
--
You received this message because you are subscribed to the Google Groups "nginn-messagebus" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nginn-messageb...@googlegroups.com.
To post to this group, send email to nginn-me...@googlegroups.com.
Visit this group at https://groups.google.com/group/nginn-messagebus.

rafal.gwizdala

unread,
Jul 22, 2016, 7:39:08 AM7/22/16
to k.sunil...@gmail.com, nginn-me...@googlegroups.com
oops,didn't understand your question. something is running these queries so either stop nginn messagebus completely or disable logging of queries



Wysłano z telefonu Xiaomi
sunil kumar <k.sunil...@gmail.com> 22 lip 2016 12:18 napisał(a):
--
Reply all
Reply to author
Forward
0 new messages