Browse by Tags

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?

Published 19 December 7 6:6 AM | SSQA.net

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes'...

Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring

SQL Server 2005 Database Mirroring - basics and related resources

Published 10 December 7 4:33 AM | SSQA.net

To provide High Availability feature within your database environment you could take advantage of Database Mirroring when using SQL Server 2005. As with all critical databases, minimizing data loss and downtime are of the highest importance. Having "AlwaysOn"...

Filed under: sql server, databases, high availability, database mirroring, tsql, best practice, production, testing

Changing ports on production SQL Server - things to watch for 1433

Published 7 December 7 12:29 PM | SSQA.net

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give...

Filed under: sql server, databases, microsoft, security, best practice, port, 1433, operating system