Browse by Tags

SQL Server BI - Managing Large Datawarehouse environment, guidelines

Published 17 September 8 3:24 AM | SqlServer-QA.net

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...

Filed under: sql server, performance, management, databases, reporting, business intelligence, data warehouse, readonly

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Published 21 February 8 6:22 AM | SSQA.net

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...

Filed under: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

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 - database maintenance gotchas

Published 3 December 7 12:43 PM | SSQA.net

What kind of database maintenance operations you should be doing when you are DBA? You should have better understanding on the terms in managing the Database platform at your end, without proper information it is very hard to say you are managing your...

Filed under: dashboard, sql server, performance, databases, security, maintenance plan

Guidelines for enabling indexes and online index operations

Published 8 October 7 8:50 AM | SSQA.net

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and...

Filed under: dashboard, sql server, performance, management, indexes, databases, indexed view, monitoring

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

Published 20 September 7 10:40 AM | SSQA.net

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...

Filed under: sql server, performance, databases, blogs, blocking, query, kba, cpu, execution plan, backups, resources, high cpu, FAQ

SQL Server 2005 using Cryptography & Encryption what they are for?

Published 13 September 7 7:46 AM | SSQA.net

Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication...

Filed under: sql server, performance, databases, microsoft, security, audit, encryption, authentication, authorization, cryptography

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.

Published 5 September 7 3:13 AM | SSQA.net

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...

Filed under: sql server, performance, databases, sqlagent, error log, recovery, suspect, message

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

Published 30 August 7 5:2 AM | SSQA.net

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...

Filed under: sql server, performance, databases, technet, benchmark, upgrade, version, best practices, compatibility

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

SET TRUSTWORTHY ON when using SP_CONFIGURE

Published 17 July 7 4:9 AM | SSQA.net

SET TRUSTWORTHY ON, from the name itself it sounds like you are not allowing anything that cannot be trusted. SQL Server 2005 has introduced a new database property called TRUSTWORTHY that is used to indicate whether the instance of SQL Server trusts...

Filed under: sql server, performance, databases, security, alter, trustworthy

Restrict Access to SQL Server using "Certificates"

Published 2 July 7 4:7 AM | SSQA.net

Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer...

Filed under: sql server, performance, databases, security, access, encryption, certificate

SQL Server 2005 Performance Dashboard Reports - making most out of it!

Published 26 June 7 4:19 AM | SSQA.net

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow...

Filed under: dashboard, sql server, performance, databases, dba, reporting

SQL Server Cursors usage and performance - cursed

Published 19 June 7 9:34 AM | SSQA.net

If you have a requirement to poll through 'n' number of rows then immediately you would think about Cursors in SQL Server. As the solution using any programming language that loops recordsets to build the attendance list that works ok, but really...

Filed under: sql server, performance, databases, dmv, hints, usage, cursor, table