craig_welton
Legendary Poster
Hoping for some info from SQL Server heroes ...
64 Bit 2008 SQL Server. E1 9.0 8.98.4.2
UBE performance is lacking compared to the 8.10 install on SQL Server 2005. In some cases 3 to 5 times slower per batch program. DBA tracing has shown complex queries executing, waiting and then being sent again with the (NOLOCK) modifier. We understand this can be controlled through the SQLServer timeout settings in the server INI. Anyone have any advice or thoughts on propper settings? The 8.10 (SQL 2005) is set to 8 seconds timeout and 3 retries.
Is the existence of these timeouts indicative of a larger, systemic problem?
thanks,
Craig
64 Bit 2008 SQL Server. E1 9.0 8.98.4.2
UBE performance is lacking compared to the 8.10 install on SQL Server 2005. In some cases 3 to 5 times slower per batch program. DBA tracing has shown complex queries executing, waiting and then being sent again with the (NOLOCK) modifier. We understand this can be controlled through the SQLServer timeout settings in the server INI. Anyone have any advice or thoughts on propper settings? The 8.10 (SQL 2005) is set to 8 seconds timeout and 3 retries.
Is the existence of these timeouts indicative of a larger, systemic problem?
thanks,
Craig