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 […]

Troubleshooting MSQL Slowness

sp_who2 is one of the most useful and widely used stored procedures, along with its predecessor sp_who. However it is also one of the most frustrating as it only takes a single parameter and the results cannot be ordered. For a large server with a lot of connections this can be a real nuisance. I […]

SQL Server 2012:Reset Password emergency

https://technet.microsoft.com/en-us/magazine/jj853293.aspx SQL Server 2012: Password emergency If the unthinkable happens and you forget your SQL Server password, there are ways to get back into the system. Saleem Hakani You’re a proud and a trusted DBA at your organization. You’re responsible for maintaining and updating several important services running on SQL Servers in your production environment. […]

SQL Server is started but didn’t listen on any port

http://dba.stackexchange.com/questions/54767/sql-server-is-started-but-didnt-listen-on-any-port Question: I newly installed SQL Server 2012. No database created yet. And I can open the Management Studio with sa/password. The Binn\sqlservr.exe is started as a service and I can see it started in the service list. However, it didn’t listening the 1433 port, or even, not listening any port by default, as I […]

Some Mysql commands

https://serveradminz.wordpress.com/category/mysql/ 1. To select a database mysql> USE database; Mysql cpanel – mysql -uroot -p`grep pass /root/.my.cnf | cut -d ‘”‘ -f 2` 2. To list databases mysql> SHOW DATABASES; 3. To list tables in a db mysql> SHOW TABLES; 4. To describe the format of a table mysql> DESCRIBE table; 5. To create a […]

Importing and Exporting SQL Server Data on Amazone RDS

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html Importing and Exporting SQL Server Data Use the following procedures to import data into and export data from an Amazon RDS SQL DB instance. Topics Importing Data into SQL Server on Amazon RDS Exporting Data from SQL Server on Amazon RDS Importing Data into SQL Server on Amazon RDS If you have an existing […]

How To Restore a SQL Server BAK file to Amazon RDS

http://www.somacon.com/p586.php is article describes how to restore a SQL Server database backup file (.bak) to a SQL Server database hosted on Amazon’s Relation Database Service (RDS). 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 […]