Browse by Tags

• analysis
• benchmark
• best practices
• compatibility
• connectivity
• error log
• long
• message
• perfmon
• query
• recovery
• running
• SQL Server
• sqlagent
• ssis
• suspect
• sysmon
• technet
• tsql
• tuning
• upgrade
• version
• web seminar
• webcast

• Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.

  Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for Read More... Posted Wednesday, September 05, 2007 6:13 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, error log, recovery, suspect, message, sqlagent

• Setting database compatibility to SQL 2000 on a SQL Server 2005 instance?

  No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000 Read More... Posted Thursday, August 30, 2007 8:02 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, version, upgrade, best practices, benchmark, compatibility, technet

• TSQL to detect long running queries against the database

  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, r.status, Read More... Posted Wednesday, August 29, 2007 9:37 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, query, tsql, running, long

• How to Analyze the PERFMON (SYSMON) data?

  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 Read More... Posted Tuesday, August 21, 2007 4:26 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, tsql, analysis, tuning, sysmon, perfmon

• High Performance Connectivity for SQL Server 2005 and SSIS

  High-speed heterogeneous integration is a challenge for many corporate IT departments today. Most modern IT groups are having to deal with an incredible amount of disparate systems across the organization, coupled with an ever-growing data set. To address Read More... Posted Friday, August 17, 2007 6:49 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, webcast, ssis, connectivity, web seminar