High LATCH_EX wait
What is LATCH_EX wait? Our LATCH_EX wait are very high, what do I need to look at to fix this?
Answer Question
| May 3, 2011 6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance
What is LATCH_EX wait? Our LATCH_EX wait are very high, what do I need to look at to fix this?
Answer Question
| May 3, 2011 6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance
Slow response with SQL server over a network.
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]
Answer Question
| April 5, 2011 5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]
Answer Question
| April 5, 2011 5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance
SQL SERVER 2005 Storage Performance
We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. [...]
Answer Question
| January 18, 2011 6:30 PM
SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance, Windows Server 2003, Xiotech
We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. [...]
Answer Question
| January 18, 2011 6:30 PM
SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance, Windows Server 2003, Xiotech
SQL Express 2005 query times lagging
I execute some simple queries on my own system’s sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server’s sql server express 2005, the queries execution time is about 3 seconds or more and I don’t know why. both of the systems have the [...]
Answer Question
| September 15, 2010 7:40 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query
I execute some simple queries on my own system’s sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server’s sql server express 2005, the queries execution time is about 3 seconds or more and I don’t know why. both of the systems have the [...]
Answer Question
| September 15, 2010 7:40 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query
SQL Server 2005 Performance
1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?
Answer Question
| August 10, 2010 6:40 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance
1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?
Answer Question
| August 10, 2010 6:40 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance
Database Log File sql server 2005
We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the [...]
Answer Question
| August 10, 2010 4:35 PM
RAID, SQL Server 2005, SQL Server 2005 performance, SQL Server logs, SQL Server performance
We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the [...]
Answer Question
| August 10, 2010 4:35 PM
RAID, SQL Server 2005, SQL Server 2005 performance, SQL Server logs, SQL Server performance
SQL Server 2005: Improving performance of Multiple Databases & LUNS
I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as [...]
Answer Question
| June 22, 2010 5:25 PM
Cluster management, LUN, RAID 10, SQL Server 2005, SQL Server clustering, SQL Server performance, Storage in 2010
I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as [...]
Answer Question
| June 22, 2010 5:25 PM
Cluster management, LUN, RAID 10, SQL Server 2005, SQL Server clustering, SQL Server performance, Storage in 2010
SQL Server memory usage
I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application? Is there any data or technique which could be used?
Answer Question
| March 15, 2010 6:34 PM
RAM chip numbers, SQL Server, SQL Server memory, SQL Server performance
I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application? Is there any data or technique which could be used?
Answer Question
| March 15, 2010 6:34 PM
RAM chip numbers, SQL Server, SQL Server memory, SQL Server performance
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
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
SQL Server 2005 Performance optimiztion
I have the following setup, would like to know what’s best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files. Want to [...]
Answer Question
| December 4, 2009 4:24 PM
SQL 2005 Reporting Services, SQL Server 2005, SQL Server performance, Windows Server 2003
I have the following setup, would like to know what’s best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files. Want to [...]
Answer Question
| December 4, 2009 4:24 PM
SQL 2005 Reporting Services, SQL Server 2005, SQL Server performance, Windows Server 2003
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
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
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
SQL Server 2005 is running slow
SQL server 2005 is running very very slow while it has 32 GB ram 200 GB SAN and 4 Processor of Xneon 566 GHZ. The normal select query takes 30-35 seconds to returning 37 records. Please give me the suggestion how to increase the performance
Answer Question
| November 9, 2012 12:44 PM
SQL Server 2005, SQL Server performance
SQL server 2005 is running very very slow while it has 32 GB ram 200 GB SAN and 4 Processor of Xneon 566 GHZ. The normal select query takes 30-35 seconds to returning 37 records. Please give me the suggestion how to increase the performance
Answer Question
| November 9, 2012 12:44 PM
SQL Server 2005, SQL Server performance
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
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
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
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
Improving performance on a large SQL Server database
We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?
Answer Question
| April 26, 2009 2:46 PM
SQL Server, SQL Server databases, SQL Server performance, SQL Server Query
We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?
Answer Question
| April 26, 2009 2:46 PM
SQL Server, SQL Server databases, SQL Server performance, SQL Server Query
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
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
Backup Performance Compare
How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.
Answer Question
| April 7, 2009 4:26 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance
How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.
Answer Question
| April 7, 2009 4:26 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance
SQL View performance vs. SELECT
I am experiencing slow views on my database. If I create a view and run it, then use the same select statement from the view and run. They both return the same data, but View runs slower. My expectations was that since views are compiled, they should run faster. Could some one clearify this for [...]
Answer Question
| June 8, 2010 7:22 AM
SELECT statement, SQL Server performance, SQL Server views
I am experiencing slow views on my database. If I create a view and run it, then use the same select statement from the view and run. They both return the same data, but View runs slower. My expectations was that since views are compiled, they should run faster. Could some one clearify this for [...]
Answer Question
| June 8, 2010 7:22 AM
SELECT statement, SQL Server performance, SQL Server views
