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
Answers were Sorted based on User's Feedback
Answer / suresh
check if any indexes is created for that table if not
create it. Open connection and close immediately when no
longer in use.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is code access security?
What is a literal control?
What is the Difference between CLR & CTS?
Can you please explain the difference between thread and process?
List the types of generations in garbage collector?
Explain jit?
how to get dynamic control array position or its index position?
Where is the Version Information Stored on a assembly ? Write the Namespace to load assemblies at runtime Can you allow a class to be inherited but prevent the method from being overridden ? What happens in memory when you box and unbox a value type ? Write a progtam to convert decimal to byte without using library function.
when a program of vb.net is written in notepad it occupies always 1kb of memory why?
Name the two main parts of .net?
what are the difference between An input box and Message box ..?
how to create crystal reports in asp.net & vb.net with syntax
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)