http://cloudbasic.net/documentation/rds-sql-server-backup-restore-s3/ Backup database to S3 Under RDS Dashboard create a new option group with “SQLSERVER_BACKUP_RESTORE” option. Update your RDS instance to use the newly created option. Open SQL Management Studio, connect to RDS database and execute the following to kick off the backup: USE [msdb] GO DECLARE   @return_value int EXEC  @return_value = [dbo].[rds_backup_database]       @source_db_name […]

Best Practices for SQL Server in Azure

http://www.oakwoodsys.com/best-practices-sql-server-azure/ Most of the typical items that DBAs will hit in tuning out a server for SQL Server hold true in Azure. The three major spots you will usually focus on are OS configurations, storage configurations, and SQL Server instance configurations.  These are generalizations and, as your workload demands, there may be variations that are […]

How can I recover my MSQL sa Password?

http://www.itprotoday.com/microsoft-sql-server/q-how-can-i-recover-my-sa-password Q: I recently ran across a case where a company I worked with had lost their sa password. How can I reset the sa password? Do I need to reinstall SQL Server? A: No. In most cases you won’t have to reinstall SQL Server. If you have access to the Windows Server administrative password […]

How do I perform native backups of an RDS SQL Server DB instance?

https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/ Issue I want to perform a native backup of my Amazon RDS SQL Server DB instance so that I can store the backup file in Amazon S3, or use the backup file to restore an RDS instance later. Short Description Amazon RDS supports native backup and restore for Microsoft SQL Server databases. You can […]

How To Restore a SQL Server BAK file to Amazon RDS

http://www.somacon.com/p586.php Amazon RDS for SQL Server does not allow you to restore a .bak file (as of Apr. 2013). If you attempt to use the Restore Database… function and select a File (Device) to be restored, you will get an error saying Failed to retrieve data for this request. Amazon has disabled this function. The official Amazon documentation […]

You are here: Home >> Posts >> Database Administration >> The Accidental DBA (Day 21 of 30): Essential PerfMon counters The Accidental DBA (Day 21 of 30): Essential PerfMon counters

https://www.sqlskills.com/blogs/jonathan/the-accidental-dba-day-21-of-30-essential-perfmon-counters/ his month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our� Immersion Event for The Accidental/Junior DBA, which we present� several times each year. You can find all the […]

SQL monitor

https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/ Now that you’ve got the hang of adding counters, here’s the full list we need to add, including the ones mentioned above: These are listed OBJECT first, then COUNTER Memory – Available MBytes Physical Disk – Avg. Disk sec/Read Physical Disk – Avg. Disk sec/Write Physical Disk – Disk Reads/sec Physical Disk – Disk […]