cannot insert data sometimes

Hot Topic

Server Name?
Which system tables hold SSIS pkg information
Slow execution of queries inside transaction
Semi-additive measures in AS2005 Standard Edition
Cannot install SQL Server 2005 CTP on WinXP Pro machine
Message Queue Task
sp_columns in SQL2K5 gives no rows for function that return table
Connecting through ODBC
Recordset Destination
Remote Connection

SQL Server

sp_send_dbmail & COM errors.
SQL Server 2005 data export wizard did not transfer stored procedures
Get latest purchase of each vender
SQL Server 2005 Analysis Services Activity
Report Builder load failure on WAN-side of firewall
Restore Database from file
Error in Data-Driven Subscription
Connection to SQL Server 2005 Express?
Reading and writing same variable to a script
Management Studio Scripting Bug?

cannot insert data sometimes

The database sometimes cannot insert data through the visual basic 6.0 application. I don't know why it happens.
I watch the process id in the following path and find out many processes are in sleeping status.
In Enterprise Manager, ->SQL Server Group -> server name -> Management -> Current Activity -> Process Info

I guess the problem come from the maximum session of the process, but I am not familiar with the database infrastructure.
Whether has the maximum session of the procees If have, What is the maximum session of the procees

My environment is SQL Server 2000 Standard Edition on the Windows 2000 Server.

Thanks a lot.

Alex

Answer this question

cannot insert data sometimes

  • partnerinflight

    >>The database sometimes cannot insert data through the visual basic 6.0 application

    So what you get instead, then


  • Gingerbitsjock

     

    gavrilenko_s

    Thank you for your attention

    I do nothing. The problem will restore automatically after a night or a few hours.

    I make sure this is not the network problem because I verify the good status of  network using "My Network Places".

    addition informaiton:

    MS SQL installed Service Pack 3

  • monstero

    Sounds like a blocking scenario. The current activity window isn't always a good indicator of blocking - you'll want to take a look at this support article for tips on tracking down the offending processes.

    http://support.microsoft.com/kb/271509/en-us



  • James 2

    thanks you gavrilenko_s and JHalmans

    I will use your suggestions to track the problem.

    alex

  • Vik B

    I'd recommend you to use the Profiler to trace what client sends to the server and what's going on then while your application is unable to insert data. sp_who() and sp_lock() will help you to identify if there are any locks and blocks or not.
  • cannot insert data sometimes
Answer this question