ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  VB.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
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
 Question Submitted By :: Raj
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1
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 ?    1 Yes 0 No
Ram
 
  Re: 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
Answer
# 2
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 ?    1 Yes 0 No
Suresh
 
 
 

 
 
 
Other VB.NET Interview Questions
 
  Question Asked @ Answers
 
Is VB.NET object oriented? What are the inheritances does VB.NET support ? Digital-GlobalSoft11
How do you rate yourself in .NET ? Infosys3
how to create crystal reports in asp.net & vb.net with syntax  1
what are the difference between An input box and Message box ..?  3
sir how i can calculate the value of two-textbox of gridview and show result in textbox within gridview in asp.net with vb.net..plz sir reply me Biz-Technology1
What is the difference between Dataset and Recordset?  7
hello friends.. when i deployment my project in the client machine that is successful but whenever i try to run my project using .exe file then it gives me error "<filename>.exe is not a valid win32 application." what i do somebody halp me pls  1
ColumnMapping belongs to which namespaces?  1
in my windows application i have to show excelwork sheetwhich is stored in the local system can any one tell me the code?  1
when a program of vb.net is written in notepad it occupies always 1kb of memory why?  1
Advantage of vb.net over vb ? Digital-GlobalSoft5
is it possible to use flexgrid in vb dotnet? Microsoft7
What are Major Feature of VB.NET Over C#.NET  9
what are the advantages and diadvantages of active reports over crystal reports ? IBM1
1234 123 12 1 how to design above pic in vb.net? ABC2
wht is the use of console application?  3
How to Insert a TextBox value in to Sql database using VB.Net coding?  3
In Datagrid after adding row, how you will assign the value for each cell to currently added new row?  1
Where would you use Abstract class and Interface?  2
What is DLL hell?  2
 
For more VB.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com