All Questions
Tagged with timeout sql-server
17
questions
3
votes
1
answer
8k
views
Importing bacpac file with 25000 tables on SQL Server fails with timeout
I'd like to import a bacpac file that was exported from an 500MB DB that however has around 25000 tables. The bacpac itself is around 18MB.
Importing through the UI of SQL Server Management Studio ...
- 425
0
votes
3
answers
8k
views
Sql server transaction timeout
Is there any parameter to prevent long transactions?
I would like to automatically rollback all transaction that takes more than 5 minutes. Is it possibile?
I'm working on a Microsoft SQL server 2008 ...
- 1,364
0
votes
1
answer
7k
views
SQL Server Timeout issues at random times causing performance degradation
I am having random timeout during a brief period of time on certain days. My CPU, Memory looks fine. So I ran Performance Monitor during these spikes and found my average disk sec/read was 5.8 ...
- 234
5
votes
2
answers
14k
views
MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?
I have a Microsoft Sql Server that handles a moderate amout of traffic for a company software suite made up of multiple clients in java and c#.
It is getting overloaded with 'Suspended' queries. They ...
- 247
1
vote
0
answers
74
views
Server network communication stalls
I'm running SBS 2008 as a file server, SQL server, IIS7 Server, and Exchange server, and very recently I am getting some very confusing stalls on it. During these "stalls," file services will cause ...
- 11
-1
votes
2
answers
8k
views
SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts
Which time out value does SQL server take into consideration while executing a query or stored procedure? The application timeout is set at 20 minutes. The SQL query/command timeout is set at 10 ...
- 1
1
vote
1
answer
1k
views
MS SQL Server 2000 timeout error with no apparent cause
Morning All,
I'm having trouble with query timeouts in MS SQL Server 2000. It is used as a backend for Intuitive ERP, a rather old ERP system based on MS Access.
My problem is that, when performing ...
- 121
2
votes
2
answers
249
views
Timeout in connection to a SQL Server instance in LAN
From one windows 7 machine I cannot connect anymore to any sql server instance that is in LAN and in same domain of this particular machine. I cannot connect from Management Studio, but also from any ...
- 253
1
vote
4
answers
5k
views
sql deadlocking and timing out almost constantly
Looks like today is going to be another rubbish one.
We have recently updated our sql box with a complete monster, with loads of cores and ram, however we are stuck with our old DB schema which is ...
- 163
3
votes
3
answers
2k
views
Timeouts when connecting to SQL Server since installing SP1 for Windows 7
I just installed SP1 for windows 7 and I have severe performance degradation when connecting to SQL Server 2005 since then. Establishing connection takes more than 30 seconds while it's instantaneous ...
- 143
1
vote
1
answer
1k
views
How to Troubleshoot Timeout on Web Requests, Connection Pool Errors, Data Locking, etc
I have a question, and am hoping someone here can help. I am running a .NET web application, and am receiving an error under certain circumstances. The error is "System.Data.SqlClient.SqlException: ...
- 111
2
votes
3
answers
11k
views
Large insert/update in table causes timeout while SQL Server re-arrange indexes
We insert/delete about 1 million rows of a two million rows table with SSIS.
We have 20 indexes on this table.
Right after the SSIS finished, we're experiencing timeouts in the frontend.
The ...
0
votes
2
answers
6k
views
Select Distinct/Unique Rows from a Huge Table in SQL Server Without Timeout Errors
I have a table in SQL Server with around 400,000 rows. Unfortunately, this table has many duplicate rows, as there isn't a primary key. I'm using SELECT DISTINCT to get all unique rows, but as there's ...
- 211
1
vote
2
answers
235
views
SQL Server Express 2005 cannot connect
I have a SQL Server Express 2005 install on a godaddy virtual terminal which currently is only connected to(locally with mgt studio) every few days or so. Every time i try to connect I get a cannot ...
jp
2
votes
3
answers
4k
views
MS Access gets Disconnected
I have MS Access 2003 application connected to SQL Server 2005 with linked tables. Starting from yesterday when I open a linked tabled and leave it open for a while (5~10 minutes) then the database ...
- 137