SQL Server Performance Tuning

Reducing SQL Server backup and restore time

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

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? Software/Hardware used: sql server 2005

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.

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

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

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

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

SQL 2000 db transactions/sec

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.

SQL Server 2000 performance issues

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

Why and how to performance tune SQL Server 2005

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?

SQL Server 2005 Memory

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?

Improving the performance of a SSRS report in SQL Server 2005

How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables

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

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

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.

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.

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

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

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

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