Chirag's questions -server

Chirag

Asked: 2009-09-18 02:45:44 +0800 CST

SQL Error Log Message- 'ACCESS_METHODS_SCAN_RANGE_GENERATOR'

One of our SQL2005 Enterprise Servers running on Win2003 became unresponsive and on reboot I saw these errors logged before it went down.

Date 17/09/2009 10:16:22 Log SQL Server (Archive #1 - 17/09/2009 10:17:00)

Source spid111

Message Timeout occurred while waiting for latch: class 'ACCESS_METHODS_SCAN_RANGE_GENERATOR', id 000000002A761760, type 4, Task 0x000000000E609EB8 : 14, waittime 600, flags 0x1a, owning task 0x000000000E6129B8. Continuing to wait.

Anyone know what this error points or relates to? Many thanks in advance.

Chirag

Asked: 2009-08-29 04:13:38 +0800 CST

How does the Proportional fill Algorithm in SQL 2005/2008 work?

When we setup multiple data files for tempdb I understand SQL Server uses a Proportional Fill algorithm. How does it work? Does it use the same method for user databases aswell.

I have tried to understand it using the SQL Internals Viewer but was unable to get consistent results and hence am a bit confused.

SQL Error Log Message- 'ACCESS_METHODS_SCAN_RANGE_GENERATOR'

How does the Proportional fill Algorithm in SQL 2005/2008 work?

Can you pass user/pass for HTTP Basic Authentication in URL parameters?

Ping a Specific Port

Check if port is open or closed on a Linux server?

How to automate SSH login with password?

How do I tell Git for Windows where to find my private RSA key?

What's the default superuser username/password for postgres after a new install?

What port does SFTP use?

Command line to list users in a Windows Active Directory group?

What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?

How to determine if a bash variable is empty?