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

View Answer   |  May 20 2008   7:36 AM GMT   |  asked by Fartman
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   |  May 14 2008   3:36 AM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, Index Performance, SQL

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.

View Answer   |  May 14 2008   3:20 AM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, Disk drives, Defragment

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 or do something to reduce the size.The LDFs...

View Answer   |  May 2 2008   3:30 PM GMT   |  asked by Ellie
SQL Server 2000, SQL Server performance tuning, SQL Server logs

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

View Answer   |  Apr 30 2008   6:01 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, SQL error messages, 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...

View Answer   |  Apr 28 2008   3:34 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, SQL database

Is it possible to increase the amount of memory used by SQL Server 2005 to speed up response time?

We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining...

View Answer   |  Apr 25 2008   2:27 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, SQL Server 2005, SQL Server memory

Looking to resolve SQL Server performance problems caused by using many temporary tables

I need your advice on the SQL Server performance tuning.The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site."RamDisk presents a powerful solution to this problem by providing up...

View Answer   |  Apr 10 2008   2:23 AM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, Disk storage, SQL Server 2000

SQL Server beginner looking for advice on performance tuning and maintenance

I am particularly new to database management. I would like to know what I should monitor everyday on SQL Server. We have 40 databases – all the users complain to me that it is very slow. The hardware part is OK. Please tell me how I can tune & maintain databases. Where should I start? It is a...

View Answer   |  Apr 3 2008   8:23 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning

Decreasing CPU usage on SQL Server 2005

My SQL Server 2005 is installed in Windows Server 2003. CPU usage is always 90-100%. If more users connect to this SQL server using their local Management Studio, then the server will become very slow. Can you please tell me how to decrease CPU usage on this SQL Server – is there a step-by-step...

View Answer   |  Mar 16 2008   10:26 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, SQL Server 2005

Settng Memory Sql Server 2005 SP2 64Bit

HiI've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance?Thank YouBest RegardsVincenzo

View Answer   |  Feb 28 2008   4:19 PM GMT   |  asked by Nuanda7777
SQL Server, SQL Server 2005, SQL Server performance tuning

Retrieving large binary objects

Server: SQL Server 2005 SP2 on Windows 2003 R2, Quad Core, 4GB Ram, Gigabit Ethernet Client: Windows XP SP2, Dual Core, 1GB RAM, Gigabit EthernetI am retrieving images from my database across the network and am concerned about thruput. It seems to me when I request a 300k image that it will be sent...

View Answer   |  Nov 29 2007   7:13 PM GMT   |  asked by JButtery
SQL Server 2005, Windows Server 2003, SQL Server performance tuning