June 28, 2013 at 9:53 am
We have a lot of applications running in the background that constantly send the request to SQL tables in SQL server 2008, then we also have about 100 users accessing a web application that has the same database as the backend.
I would like to have some input on developing a process queue system based on CPU usage for the application request. For .e.g. an application A that uses intensive query checks the CPU usage and if the usage is hight it will not run, something like that.
Any input would be greatly appreicated.
June 28, 2013 at 10:45 am
Looks like this question would be much better for a .NET forum. Ultimately, it is not a SQL question, but a windows service question.
Jared
CE - Microsoft
June 28, 2013 at 12:19 pm
This sounds like a job for..."Super Duck!!!". Oh wait...wrong thread.
err...have you looked at the resource governor? It can handle all these things pretty nicely.
http://msdn.microsoft.com/en-us/library/bb933866.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply