VPN Hollander Powerlink Server issues
I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having [...]

Answer Question   |  March 31, 2012  3:34 AM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3

Storage Area Network Configuration IOPS
I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting [...]

Answer Question   |  January 17, 2011  11:10 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks

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

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

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

How to use Insert command between two servers to speed up performance
We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the [...]

Answer Question   |  April 19, 2010  4:34 PM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance

Bulk-Logged Recovery Model SQL Server 2005
If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do?

Answer Question   |  August 22, 2009  5:06 PM
SQL, SQL Server 2005, SQL Server 2005 performance

Performance issues with a large table in SQL Server 2005
I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup for this in which [...]

Answer Question   |  May 18, 2009  12:11 AM
SQL Server 2005 performance, SQL server 2005 performance tuning, SQL Server query optimization

How to check Max Worker Threads in SQL Server 2005
We’ve had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

Answer Question   |  March 21, 2009  7:08 PM
Max Worker Threads, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 performance

SQL Server 2005 Memory
My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set ‘lock page on memory’, but Task Manager show only 4.50GB only and performance monitor show SQL server manager – total memory on 4GB. Expert: Do I setup memory wrong?

Answer Question   |  March 9, 2009  10:46 PM
SQL Server 2005 administration, SQL Server 2005 memory, SQL Server 2005 performance

Migration from SQL Server 2000 to SQL Server 2005
Hi EveryBody, I am new to SQL SERVER 2005, I have migrated my SQL SERVER 2000 database to SQL SERVER 2005 and it has degraded my site performance. A Page that opens in 10 seconds is now opening in 30 seconds. I have updated the STATISTICS of the database using UPDATE STATISTICS command but no [...]

Answer Question   |  January 29, 2009  4:56 AM
SQL Server 2000 migration, SQL Server 2005 migration, SQL Server 2005 performance, SQL Server migration