Browse by Tags

All Tags » databases   (RSS)
SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   
In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...
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.
21 February 08 05:22 AM | SQL Master | 2 Comments   
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 Read More...
How to monitor transaction activity between the databases?
10 January 08 03:23 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server SP_HELPINDEX - updated version that includes column names
03 January 08 12:46 PM | SQL Master | 2 Comments   
Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA Read More...
SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?
19 December 07 05:06 AM | SQL Master | 3 Comments   
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' for all the Read More...
Changing ports on production SQL Server - things to watch for 1433
07 December 07 11:29 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server - database maintenance gotchas
03 December 07 11:43 AM | SQL Master | 2 Comments   
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 Read More...
Guidelines for enabling indexes and online index operations
08 October 07 06:50 AM | SQL Master | 4 Comments   
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 Read More...
High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
20 September 07 08:40 AM | SQL Master | 2 Comments   
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, Read More...
SQL Server 2005 using Cryptography & Encryption what they are for?
13 September 07 05:46 AM | SQL Master | 2 Comments   
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, Read More...
How to get rowcount efficiently within a SSIS package?
05 September 07 01:50 AM | SQL Master | 2 Comments   
I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components Read More...
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.
05 September 07 01:13 AM | SQL Master | 2 Comments   
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...
How to Analyze the PERFMON (SYSMON) data?
20 August 07 11:26 AM | SQL Master | 2 Comments   
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...
The database principal owns a schema in the database, and cannot be dropped'
13 July 07 01:10 AM | SQL Master | 0 Comments   
Check this FAQ post for further resolution. Read More...
Restrict Access to SQL Server using "Certificates"
02 July 07 02:07 AM | SQL Master | 1 Comments   
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) Read More...
More Posts Next page »