Interested to Buy Any Domain ? << Click Here >> for more details...
I want to reduce my CPU Usage when I am querying the
Database for records. Now my Winform App(in VB.Net)
suddenly Jumps to 100% CPU Usage when i query for records
from sql server database. I want this Usage to be less. Any
help is appreciated
- 2 Answers
- 6790 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
you need to check the following things:
1. Database size is very high and you are using query which
is not optimized.
2. you must be using too many joins in the query. Check the
execution plan
3. Confirm whether the CPU utilization is more from database
end or application end
http://www.interview-questions.maxmice.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
List the types of generations in garbage collector?
Explain public assembly?
Explain about delegate?
What is non_deterministic finalization?
What do you mean by serialization?
What are the technology areas that microsoft.net contains?
Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?
How many languages are supported by .net?
Explain about the ruby interface generator?
Explain the difference between web.config and machine.config and where it will be ?
What is globalization?
How would you implement inheritance using vb.net?
What is the differences between dataset.clone and dataset.copy?
what is diffrence constructor and destructor in vb
What is the advantages of VB.NET?
