Today faced an issue that SQL server agent was not starting up, after investigation found that issue is due to AWE and lock pages in memory settings , found a very useful article at following link It says,  I changed my SQL Server Agent service account to a domain account using SQL Server Configuration Manager (should always use this tool to manipulate service accounts), but then could not start the SQL Server Agent service. This […]

Today after searching for possible causes of OLEDB timeout error faced by an application came across various links and lastly found a useful link  Article states:  I have heard many people saying that their web site is chugging along, and suddenly they get this error:    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)  [Microsoft][ODBC SQL Server Driver]Timeout expired   or    Microsoft OLE DB Provider for SQL Server error ‘80040e31’  Timeout expired   This […]

Today while debugging a C: drive disk space issue found that in certain service account location C:\Users\\AppData\Local\Temp there are several “*.CACHE” files. They come named as follows: “machine-name_instance.SQL-Server-name_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_#.cache” where: “machine-name” is the server’s Windows computer name; “instance.SQL-Server-name” is the MS SQL Server 2008 server and instance name; “#” is some unique 1-2 digit identifier. these were created by Data collector functionality of SQL server 2008, when you do not specify specified cache file patch in […]