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
- 6686 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
What are the objects in asp.net?
what is difference between namespace and assembly?
Define manifest?
What is the importance of a Button control?
Explain manifest?
What does assert() method do In VB.NET
Described strong typing and weak typing?
Explain the services provided by common language infrastructure.
What are the parts of the visual basic control?
Can you please explain the difference between namespace and assembly?
Explain the difference between c# and vb.net?
Define naming convention?
What is the difference between value and reference types?
What is strong typing and weak typing?
Sir, what code to store data from vb net sql server 2008 to 2005 and at the same time in order to validate the data entered is not the same, but there have been contacts in the module. Examples such as the log table that I created, the user name as the primary key.
