communication C# and sql server for every 10

Question

0.00/5 (No votes)

See more:

Hi all. I have a huge update query that effects many many records. in each reason, this query need 3 or 4 minutes for execute.
not discuss about optimize query.

I want to find this query situation by c# code for every 10 seconds or more.

Just I want to find situation of query. for example count of records are affected by c# code in every 30 seconds.

I know how can I show a news for users regularly too.

what should I do? how sql server says this to us? what I need for communication between c# and sql server? Is this possible?

Posted 6-Oct-10 2:26am

mammadkoma

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2010-10-06T02:33:00

Solution 1

If I understand your question correctly, you want to start the update, and then show progress messages every 10 seconds.

You could make the stored proc that's doing the update write a status indicator of some kind to a table, and from a thread in your app, check that status indicator every 10 seconds.

That's the way I'd try it first.

Posted 6-Oct-10 2:33am

#realJSOP

Comments

[no name] 6-Oct-10 8:41am

Yes I want start the update, and then show progress messages every 10 seconds. for example how many records are affected in every 10 seconds. what should I do?

[no name] 7-Oct-10 6:23am

No one know ???

[no name] 7-Oct-10 6:23am

Please help me ...

mammadkoma · Answer 2 · 2010-10-07T00:25:00

Solution 2

I think I should use TraceServer class. right?

Posted 7-Oct-10 0:25am

mammadkoma