Remove From My Forums

StreamInsight Query Stopped processing events after few days

Question
0

Sign in to vote

Hi

I have a stream insight instance created as a stand alone server(Hosted in windows service). and I am running quries. But i have an issue after few days of running query the some of the query stop processing events thought the event are present.

I am using windows service as a host. I am suspicious of query being garbage collected but i have no evidence for that as refrence are mantained by application object. I have observed that in last 20 day memory has raise to 200 MB is that normal.

Has sombody faced similar issue

It would be great help if any body can responde

Thanks

Monday, July 25, 2016 9:21 PM

Answers

1

Sign in to vote
Hi Bhupesh o Sharma

>> I have an issue after few days of running query the some of the query stop processing events thought the event are present.

You could have a look at following link to learn how to handle the error and add them into your service to record the detailed error information.

https://msdn.microsoft.com/en-us/library/hh290478(v=sql.111).aspx

>> I have observed that in last 20 day memory has raise to 200 MB is that normal.

About the memory issue, you could first check whether you dispose the object duly and whether you load a large amount of data in one query. Then, please refer to following article to monitor the performance of StreamInsight Server and Queries to find out the issue point.

https://msdn.microsoft.com/en-us/library/ee391166(v=sql.111).aspx

Best Regards,

Zhang Albert
- Proposed as answer by Albert_ Zhang Friday, August 5, 2016 10:20 AM
- Marked as answer by Sam ZhaMicrosoft contingent staff, Moderator Sunday, August 7, 2016 2:00 PM
Wednesday, July 27, 2016 1:22 AM