SQL Server Performance Tuning

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

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

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

Settng Memory Sql Server 2005 SP2 64Bit

Hi I'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 You Best Regards Vincenzo

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