Browse by Tags

How to monitor transaction activity between the databases?

Published 10 January 8 4:23 AM | SSQA.net

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more...

Filed under: sql server, databases, dmv, i/o, tsql, statistics, activity

SQL Server TSQL to find complete CONSTRAINT information on a table catalog?

Published 9 January 8 7:26 AM | SSQA.net

I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name...

Filed under: sql server, databases, dba, function, requirement, tsql, tablename, constraint, values

TSQL to get default location of database data and log files?

Published 8 January 8 6:37 AM | SSQA.net

By default the SQL Server database data & log files are created on the default data directory which is Program Files or based on where SQL binary files are installed. In order to find what is the default location you can run following TSQL: declare...

Filed under: sql server, databases, location, tsql, data file, log file, default, program files

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

TSQL script for deleting backups older than 1 day

Published 10 September 7 4:34 AM | SSQA.net

Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get...

Filed under: sql server, databases, backup, maintenance plan, drop, tsql, forced, older

TSQL to detect long running queries against the database

Published 29 August 7 6:37 AM | SSQA.net

When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id...

Filed under: sql server, performance, databases, query, tsql, running, long

How to Analyze the PERFMON (SYSMON) data?

Published 20 August 7 1:26 PM | SSQA.net

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data...

Filed under: sql server, perfmon, performance, analysis, databases, tuning, sysmon, tsql

Find VIEW ANY Database permission privileges for all users

Published 18 July 7 10:11 AM | SSQA.net

You may be aware that any login that is created on SQL Server will have permission or privilege to see all databases on that instance. This is due to VIEW ANY DATABASE permission that regulates the exposure of metadata system databases. This permission...

Filed under: sql server, databases, view, tsql, public