Questions tagged [command-timeout]
53 questions
0
votes
1 answer
How to set the DataContext.CommandTimeout application wide
I want to set the timeout for my DataContext Class application wide. I can find a lot of examples for C# (1, 2) translated to vb.net it would be
Partial Class SampleDBDataContext
Inherits System.Data.Linq.DataContext
Partial Private Sub…
ruedi
- 5,365
- 15
- 52
- 88
0
votes
2 answers
What is the proper way to run a long query against an active database?
We are using SQL Server 2012 EE but currently do not have the option to run queries on a R/O mirror though that is my long term goal, though am concerned I may run into the below issue in that scenario as well since the mirror would also be updating…
Dave
- 1,822
- 2
- 27
- 36
0
votes
1 answer
Alter new and existing session Command Timeout value
I’m a self-taught DBA in a manufacturing environment full of engineers who like to fiddle.
Although I have not given them sysadmin or any explicit extra rights I have an issue with some engineers running ‘killer’ queries, some very io…
Steve Smith
- 1
- 1
0
votes
1 answer
How to set "timeout" when using the method "CreateSqlStringAccessor"?
I have a code like this, how I can do to set the "CommnadTimeout"?
var database = EnterpriseLibraryContainer.Current.GetInstance();
var sqlGetAllPersons = @"select * from Person.Person";
var personMapper =…
andres descalzo
- 14,887
- 13
- 64
- 115
0
votes
1 answer
SQL Server timeout while executing stored procedure
I am experiencing a problem whereby executing a stored procedure to update a record in a table is resulting in a timeout error. I originally call my stored procedure from within an MVC3 application, which is where I first noticed the error.…
Anthony Wood
- 395
- 1
- 3
- 16
-1
votes
1 answer
Update command timeout to 0 in mysql db configuration
How to update the command timeout in mysql database. I know how to do it at application level but I want to change the command timeout at db end. So that I have to change it only at one place.
At application end I am using
"default command timeout…
mayank bansal
- 61
- 9
-1
votes
1 answer
Code takes time that varies system to system
I am facing a problem for last 15 days. I have a code which contains a do-while loop and inside that there are 4 for loops. in each loop the following function is called.
Public Function retds1(ByVal SPName As String, ByVal conn As SqlConnection,…
user3651830
- 36
- 7
-3
votes
1 answer
Command timeout property in VB
How can I override the default Command time out Property(30 seconds) to 600 seconds in VB?
I know we need to change the command time out in SQLhelper.vb
I have a code where i can see sqlcommand mentioned in the Private class.
where I need to…
Rupa
- 1
- 1
- 2