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