Click here to Skip to main content
15,877,573 members
Home / Discussions / Database
   

Database

 
GeneralIDbCommand.CommandTimeOut Pin
yyf30-Oct-03 4:21
yyf30-Oct-03 4:21 
GeneralRe: IDbCommand.CommandTimeOut Pin
Mike Dimmick30-Oct-03 4:59
Mike Dimmick30-Oct-03 4:59 
GeneralRe: IDbCommand.CommandTimeOut Pin
yyf30-Oct-03 8:07
yyf30-Oct-03 8:07 
QuestionProblem in connection string??? Pin
d meenakshi29-Oct-03 18:53
d meenakshi29-Oct-03 18:53 
GeneralRows Pin
Anonymous29-Oct-03 9:17
Anonymous29-Oct-03 9:17 
GeneralUpdate and select in same procedure with a dataadapter Pin
MrDanJordan29-Oct-03 5:49
MrDanJordan29-Oct-03 5:49 
GeneralHelp, why sql server is pending..... Pin
yyf29-Oct-03 4:09
yyf29-Oct-03 4:09 
GeneralRe: Help, why sql server is pending..... Pin
Jeff Varszegi3-Nov-03 15:07
professionalJeff Varszegi3-Nov-03 15:07 
Is the machine paging? Pull up the Performance MMC and start looking at more than just processor: disk use, especially paging, is a good place to start. Then get back to me with the details.

Another thing is that depending on how you've got your Query Analyzer etc. set up, you can be inadvertently locking tables by using them through the GUI. I recommend exiting all your client stuff, then starting with just one thread running the query, then two, four, eight, etc. Throw on all the performance monitors you can stand. After a few hours of fiddling around, you will at least have more idea of what's going on on your machine performance-wise.

Also, you should pull up the query plan of your query and analyze it for possibility of deadlock. You can try running it simultaneously through several connections in QA to see if you can cause a deadlock, but I think it's usually better to just try to spot these things with the eye. Look for the possibility of putting two threads at cross purposes, where one thread has resource A and waits on B, while another thread is in the reverse situation. The easiest way to avoid this sort of thing is by making sure you always access things in the same order, and never backtrack if possible. (This is almost always possible to do.)

Sorry if some of this seems like newbie info-- I don't really know your full situation.

Thank you.

Jeff Varszegi
Generalabout connection pooling Pin
yyf28-Oct-03 10:12
yyf28-Oct-03 10:12 
QuestionThe functions in ADO.NET are asynchronism or synchronism? Pin
yyf28-Oct-03 9:14
yyf28-Oct-03 9:14 
GeneralDebugging a Stored Proc Pin
Dave S28-Oct-03 3:10
Dave S28-Oct-03 3:10 
GeneralRe: Debugging a Stored Proc Pin
Mike Dimmick28-Oct-03 3:15
Mike Dimmick28-Oct-03 3:15 
GeneralRe: Debugging a Stored Proc Pin
Jörgen Sigvardsson30-Oct-03 9:33
Jörgen Sigvardsson30-Oct-03 9:33 
GeneralDataTable.Select Pin
Ryan_Roberts28-Oct-03 2:41
Ryan_Roberts28-Oct-03 2:41 
GeneralPlease point me in the right direction... Pin
frank2127-Oct-03 9:00
frank2127-Oct-03 9:00 
GeneralRe: Please point me in the right direction... Pin
Aryo Handono31-Oct-03 3:15
professionalAryo Handono31-Oct-03 3:15 
Generalconnection pooling Pin
yyf27-Oct-03 7:59
yyf27-Oct-03 7:59 
GeneralRe: connection pooling Pin
Jörgen Sigvardsson30-Oct-03 9:38
Jörgen Sigvardsson30-Oct-03 9:38 
GeneralProcess SQL Transactions?? Easy Question :) Pin
mittalpa27-Oct-03 6:41
mittalpa27-Oct-03 6:41 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
Mike Dimmick28-Oct-03 2:13
Mike Dimmick28-Oct-03 2:13 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
mittalpa28-Oct-03 3:17
mittalpa28-Oct-03 3:17 
GeneralMemory Leak! Pin
Kevin Gutteridge27-Oct-03 0:36
Kevin Gutteridge27-Oct-03 0:36 
GeneralRe: Memory Leak! Pin
Mike Dimmick28-Oct-03 3:00
Mike Dimmick28-Oct-03 3:00 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:03
Kevin Gutteridge28-Oct-03 22:03 
GeneralRe: Memory Leak! Pin
Mike Osbahr28-Oct-03 3:38
Mike Osbahr28-Oct-03 3:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.