Dear friend,

Check all the logshipping related tables in primary,secondary and monitor server related to your deleted logshipping database,if it exists ,remove the data manually to avoid the alert.

Ensure the missing objects exists in the DB2 database before data transfer to SQL server!

Hi,

Check for any connection into that database by profiler?

AS Gila info,Database size,IO throughput and also depends on backup destination (to tape,SAN or local disk)!

AS Gila info,Database size,IO throughput and also depends on backup destination (to tape,SAN or local disk)!

if you set immediate_sync to true in transactional replication--->The data in the distribution database replicated tables should be maintained through out the retention period .We need to set immediate_sync to...

This article will help you !

http://www.sqlservercentral.com/articles/Monitoring/67546/

Whats wrong in that?Go ahead and change it buddy!!

Hope after some modify,it will helps!

select [object_name], [counter_name], [cntr_value]

from master.dbo.sysperfinfo

where counter_name = 'Buffer cache hit ratio'

or counter_name = 'Buffer cache hit ratio base'

This query actually tells you the CPU utilization by SQL Server 2008, in one minute increments.

-- Get CPU Utilization History for last 30 minutes (SQL 2008)

DECLARE @ts_now bigint = (SELECT...

Post it in appropriate forum topic to get answers.

Refer the post.

http://technet.microsoft.com/en-us/library/cc770266%28v=ws.10%29.aspx

It is for :

collect event driven information about sql server systems.

Replace the existing SQL profiler concept that most of the DBA depends.

yes..Check your access in the development environment and if not,get access and try to install SQL.

Else login through servcie account and try the installation of SQL?

Reply with the execution results you got in it.

Backup operations do not take locks on user objects. Backups do cause a really heavy read load on the I/O subsystem so it might *look* like the workload is...