SQL SERVER 2005 Performance Monitoring
Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

Answer Question   |  January 6, 2012  6:40 PM
SQL Server 2005, SQL Server performance, SQL Server Performance Monitoring, SQL Server performance tuning

Reducing SQL Server backup and restore time
Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried “piecemeal” restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the filegroups — except for the [...]

Answer Question   |  October 27, 2009  4:39 PM
Backup and restore, SQL Server backup and restore, SQL Server performance tuning

Is having the auto create statistics on in a database a good thing?
Hello I have a 250GB database and the auto create statistics is on is that a good thing?

Answer Question   |  October 23, 2009  2:08 AM
SQL Server 2005, SQL Server administration, SQL Server performance, SQL Server performance tuning

Resource usage of SQL Server 2005 Generate Script
Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

Answer Question   |  October 13, 2009  12:28 PM
SQL Scripting, SQL Server 2005, SQL Server performance, SQL Server performance tuning, SQL Server Scripts

System hangout
I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem

Answer Question   |  June 10, 2009  1:11 PM
HCL, SQL Server performance, SQL Server performance tuning

Tuning and viewing SQL Server reports
I have developed several reports and deployed on the remote server. While running reports on a browser, it takes about 20 to 30 seconds, but when i browse the same on the remote server, reports get displayed in 5-8 seconds. Do I need to tune my server to enhance its performance, and how should I [...]

Answer Question   |  May 2, 2009  7:23 PM
SQL Server performance, SQL Server performance tuning, SQL Server Reports

SQL Error
hi i am getting error primary filegroup is full. create a space by deleting unneeded files,dropping objects in the filegroup. I have disk space 30gb then also the error please help

Answer Question   |  April 26, 2009  3:44 PM
SQL Server, SQL Server error messages, SQL Server performance, SQL Server performance tuning

Adding SQL perfrmon counters
Recently a site administrator installed a SQL2000 server on Windows 2003. For some reason the perfmon counters for SQL do not show up when trying to check performance. How should these counters be added and/or activated post-installation? In the IT trenches? So am I – read my IT-Trenches blog

Answer Question   |  April 8, 2009  2:26 PM
SQL Server 2000, SQL Server performance, SQL Server performance tuning, Windows Server 2003

SQL 2000 db transactions/sec
What number of SQL 2000 database transactions/sec would be of concern on a system? Windows Server 2003, 4GB RAM, 2CPU (dual core). Thanks for the guidance.

Answer Question   |  March 11, 2009  2:25 PM
SQL Server 2000, SQL Server database, SQL Server Database Transactions, SQL Server performance, SQL Server performance tuning, Windows Server 2003

SQL Server 2000 performance issues
Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database application is a manufacturing information [...]

Answer Question   |  February 16, 2009  7:05 PM
iSCSI, perfmon, SAN, SQL Server 2000, SQL Server performance, SQL Server performance tuning

Why and how to performance tune SQL Server 2005
Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better – SQL Server 2000 or SQL Server 2005?

Answer Question   |  February 4, 2009  6:30 PM
SQL Server 2000, SQL Server 2005, SQL Server performance tuning

SQL Server 2005 Memory
SQL server 2005 running on windows XP, memory grows steadily then SQL(system) hangs when memory gets to 1.7 gb…Server must be re-started. What could cause this?

Answer Question   |  January 29, 2009  1:22 PM
SQL Server 2005, SQL Server memory, SQL Server performance, SQL Server performance tuning, Windows XP

Improving the performance of a SSRS report in SQL Server 2005
How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

Answer Question   |  November 19, 2008  7:13 PM
SQL Server 2005, SQL Server performance tuning, SQL Server Reporting Services

PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables
how to improve insert performance in insert into mis_fcr_all_txns_susp_temp (select * from mis_fcr_all_txns_combi a where exists (select acct_no from mis_fcr_all_txns_fraud3 b where a.acct_no = b.acct_no) and a.TXN_DATE BETWEEN (REPORT_DATE – 60) AND (REPORT_DATE – 30));

Answer Question   |  September 18, 2008  1:03 PM
INSERT statement, SQL Server performance tuning

Sql server 2005 database filesize auto grow
Hi i’m running sql server 2005 sp2 on a w2k cluster; i’m expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it. Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the [...]

Answer Question   |  May 20, 2008  7:36 AM
SQL Server 2005, SQL Server performance tuning

Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem
I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I’ve checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.

Answer Question   |  September 28, 2008  3:36 AM
Index Performance, Index Tuning Wizard, ITW, SQL, SQL Server errors, SQL Server performance tuning

Will defragmenting hard disks improve SQL Server performance?
Does it help to defragment the local hard disks on SQL Server to improve performance? I just started a new position and the drives on the servers are very fragmented. Could defragmenting them help boost some performance? Thanks.

Answer Question   |  January 30, 2012  3:20 AM
Defragment, Disk drives, SQL Server performance tuning

DB size
Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space. Anyone has any idea how to shrink the DBs [...]

Answer Question   |  May 5, 2008  3:30 PM
SQL Server 2000, SQL Server logs, SQL Server performance tuning

How to use partitioning in SQL Server database to avoid ‘timeout’ errors
We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no [...]

Answer Question   |  May 2, 2008  6:01 PM
Partitions, SQL error messages, SQL Server performance tuning, Timeout

Why might a maintenance plan fail to generate a SQL Server job?
I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one instance, only the [...]

Answer Question   |  May 23, 2008  3:34 PM
SQL Database, SQL Server performance tuning