Oops.. I missed the Restart.

Thank You,

Best Regards,

SQLBuddy

Hi Roy,

[SQLServer:Memory Manager][Target Server Memory (KB)] 221.000

[SQLServer:Memory Manager][Total Server Memory (KB)] 29.599

Why this disparity ? SQL wants to use 221 GB. But SQL is using only 29.5 GB.

But the total...

1. A better method would be to use Execute SQL Task and send Email using that. However, for this to work you need to setup the DatabaseMail first

EXEC sp_send_dbmail @profile_name='Profile_Name',

@recipients='youremail@Example.com',

@subject='Test...

What is your actual concern ?

Thank You,

Best Regards,

SQLBuddy

You can't shrink TempDB if it's in use.

Check this

http://support.microsoft.com/kb/307487

Thank You,

Best Regards,

SQLBuddy

What is the Size of the Page File ?

Try to disable any unnecassary or unused windows services on the server and see it it frees up some memory on the...

Use 64 Bit Machine as the Server and good amount of Memory like 32 GB + , Seperate the Tlogs, Datafiles, TempDB , Backups onto seperate drives , http://www.sql-server-performance.com/articles/per/Characterizing_IO_Workload_p1.aspx

Split Tempdb...

Check the errors logs to to find the root cause of the issue and setup summary file.

To configure the TCP ports, pls check these links

http://msdn.microsoft.com/en-us/library/ms177440.aspx

http://www.mssqltips.com/tip.asp?tip=1412

...

Hi Ishaan,

Are you using Oracle provider for OLE DB or Microsoft OLE DB...

AFAIK, It should have the same effect.

Thank You,

Best Regards,

SQLBuddy.

Full text catalaogs are no longer stored as physical files as in SQL 2005. So you need to backup all the filegroups that contain the FT Indexes of that catalog...

As Adiga and Elliott mentioned, use Even Viewer to find the Historical Failover Info and the following query to get the current node

select SERVERPROPERTY('IsClustered') as _1_Means_Clustered

, SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as CurrentNode...

The Maintenance plan failed when it was trying to rebuild the index [index_one] ON [dbo].[table_one] due to a deadlock. The best place to check is the Maintenance Plan Log file...

AFAIK, Those pages are available only in the previous versions but not in SQL 2008 bcs MS has completely rewritten the Activity Monitor in 2008.

...

Elliott is Right. Maintenance plans are readymade tools available to do the maintenance activities. However, Stored Procs give you more control and flexibility. If you have more requirements that Mps...