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