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
- 6238 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
How many languages are supported by .net?
Explain the difference between int and int32?
What are the differences between server-side and client-side code?
what is common language specification?
What do you mean by serialization?
Write the role of new keyword?
Explain about globalization?
What are jagged arrarys ?
What is writeline in vb.net?
What is the use of system.diagnostics.process class?
What is the difference between datagrid and gridview?
What is different between web.config and machine.config and where it will be ?
Explain the services provided by common language infrastructure.
What keyword is used to accept a variable number of parameter in a method?
Explain the use of console application?
