Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2012

SQL Server – default trace FAQ

Has someone deleted a table?

Are you trying to track auto grow events?  Problem scenarios such as Database autogrow and slow database recovery

When did SQL memory usage change? Read SQL Server Performance ,memory pressure and memory usage  for SQL Server memory  analysis

SQL Server security  changes?

The default trace… Read more

0 comments, 357 reads

Posted in SQLServer-DBA on 11 April 2012

SQL Database roles and members

Q. How can I obtain the members of a role within a database?

A.  One method is to use sp_helprolemember

 

EXEC mydatabase.dbo.sp_helprolemember

--returns 
DBRole		MemberName		MemberSID
My_Admin_Role	DOMAIN\muUser	0x010500000000000515000000313CF1C8B4034LF676BJA5EE7C0D0000

For a comprehensive security audit on database roles – read Powershell sql server security audit Read more

0 comments, 330 reads

Posted in SQLServer-DBA on 10 April 2012

BACKUP LOG with TRUNCATE_ONLY is discontinued

As  a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG

 As of SQL Server 2008 , BACKUP LOG with TRUNCATE_ONLY is discontinued.   I still find plenty of SQL Server maintenance scripts using BACKUP LOG with TRUNCATE_ONLY.

 In SQL SQL Server 2008 – an… Read more

0 comments, 1,940 reads

Posted in SQLServer-DBA on 5 April 2012

SQL Server - ALTER DATABASE to set a smaller FILEGROWTH for this file.

This error message can appear in the SQL Server Error Log files .

Autogrow of file 'MY_DB' in database 'MY_DB' took 455320 milliseconds.  Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

 

What does this mean ?

 

1)       Need to analyse how you are managing… Read more

0 comments, 977 reads

Posted in SQLServer-DBA on 4 April 2012