Yes. This could be external programs effect. Check if there is antivirus running at night and if database files excluded from scanning.

I think that the first step should be checking if there are any jobs scheduled at this time or close to this time. CheckDB and index rebuild tasks usually take...

Eric Hobbs (4/15/2011)

---

Hopefully I'm not being dim here, but this seems like a lot of effort and increased overhead on your SQL database, for something that can be handled much...

I have been using SQLPing for years (http://sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx), but this method is also interesting.

Hi! I am not sure what exactly the problem is, but try to check default database for the user who executes the reports and compare it accross the servers.

They could be found in registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. Remember to backup registry keys before...

Check out this post http://www.sqlservercentral.com/Forums/Topic1073545-146-1.aspx#bm1075557. However you will not be able to find information you are looking for if you restarted the services as after restart dynamic management views do...

Here is an article with step by steps instructions: http://www.mssqltips.com/tipprint.asp?tip=1433

Keep in mind that Oracle client installation files for Windows 2003 and Windows 2008 are different.

One of the reasons could be that bottleneck is not in I/O.

SELECT t1.session_id, t1.request_id, t1.task_alloc,

t1.task_dealloc, t2.sql_handle, t2.statement_start_offset,

t2.statement_end_offset, t2.plan_handle

FROM (Select session_id, request_id,

SUM(internal_objects_alloc_page_count) AS task_alloc,

SUM (internal_objects_dealloc_page_count) AS task_dealloc

...

Yes, you can set fixed size later, but first you need to determine what is the right fixed size for you environment. Plus add some extra space for growth (20%...

I agree with Pam. 512 MB looks a little bit low for a tempdb file. Set files to autogrowth (for example up to 2 GB each file, adjust if...

Did you have chance to look at this MS article http://support.microsoft.com/kb/919224/? The article is for SQL 2005, but the problem is similar to yours.

Yes.

In some cases it would...

Something else important that you should request - installation media for all versions of SQL Server installed in company.