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
- 6813 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
Define clr?
Explain cls?
What is redim keyword?
Write a VB.Net console program to check whether a number is perfect or not.
Explain about the keyword must inherit?
Explain some of the exclusive features which are present in vb?
Allowed program to auto-correct the database when loading a presentation.
Explain what observations between vb.net and vc#.net?
Is vb.net a programming language?
List the two main parts of .net?
Can we use Vb.Net and C# language simultaneously in one .Net application?
Explain global assembly cache (gac)?
Name some different types of control?
what is diffrence constructor and destructor in vb
What do you mean by Redim in VB.NET?
