Viewing 15 posts - 16 through 30 (of 79 total)
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.
Regards,
Kumar
October 8, 2013 at 7:06 am
Ensure the missing objects exists in the DB2 database before data transfer to SQL server!
Regards,
Kumar
October 3, 2013 at 1:56 am
Hi,
Check for any connection into that database by profiler?
Regards,
Kumar
October 2, 2013 at 7:33 am
AS Gila info,Database size,IO throughput and also depends on backup destination (to tape,SAN or local disk)!
Regards,
Kumar
October 2, 2013 at 6:35 am
AS Gila info,Database size,IO throughput and also depends on backup destination (to tape,SAN or local disk)!
Regards,
Kumar
October 2, 2013 at 6:35 am
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...
Regards,
Kumar
October 2, 2013 at 6:24 am
September 30, 2013 at 5:39 am
Whats wrong in that?Go ahead and change it buddy!!
Regards,
Kumar
April 2, 2013 at 5:36 am
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'
Regards,
Kumar
April 2, 2013 at 4:55 am
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...
Regards,
Kumar
April 2, 2013 at 3:31 am
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
Regards,
Kumar
March 13, 2013 at 10:42 am
It is for :
collect event driven information about sql server systems.
Replace the existing SQL profiler concept that most of the DBA depends.
Regards,
Kumar
March 13, 2013 at 10:32 am
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?
Regards,
Kumar
March 13, 2013 at 5:16 am
Reply with the execution results you got in it.
Regards,
Kumar
March 12, 2013 at 4:28 am
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...
Regards,
Kumar
March 12, 2013 at 4:26 am
Viewing 15 posts - 16 through 30 (of 79 total)