Browse by Tags
All Tags »
performance (RSS)
If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial
Read More...
Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization
Read More...
Not alone with SQL Server you would be able to identify the root cause of a performance issue or to monitor any kind of activity. As you may be aware SYSMON (PERFMON) and PROFILER will help to some extent of finding offending processes on the SQL Server
Read More...
I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as
Read More...
You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based
Read More...
Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes
Read More...
Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this
Read More...
When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id]
Read More...
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology
Read More...
As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage. From the changes (upgrade) to the Operating System and SQL Server we now have new set of SQL
Read More...
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that
Read More...
Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required
Read More...
Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message " Microsoft SQL Server Management Studio is waiting for
Read More...
SQL Server Management Studio (SSMS) is a powerful tool in SQL 2005 that is re-written from previous of SQL Server, that also reduces the flaky features from Enterprise Manager. How to set the Animation Speed and make best use of SQL Server Management
Read More...
One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions
Read More...