SQL Server performance

SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.

I am seeing this error weekly in the sql server log with associated performance hit:WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.Has anyone resolved this error?

View Answer   |  Jul 18 2008   9:02 PM GMT   |  asked by Ftornoe
SQL Server 2000, SQL Server errors, SQL Server logs

Running a lengthy query on SQL Server 2005

We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?

View Answer   |  Jul 16 2008   8:21 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, Query, Windows Server 2003

Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory

I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always...

View Answer   |  Jul 3 2008   6:16 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2000, Memory, SQL Server performance

Slowdown on a server running SQL Server 2000 and Windows Server 2003

I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server's specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus ...

View Answer   |  Jul 3 2008   6:13 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2000, Windows Server 2003, SQL Server performance

Dealing with a hyperactive SQL Server

On occassion, our SQL Server goes hyper - 100% disk activity with I/O queues. It happens only once a year, lasts for a couple of days and then stops. We have our database administration staff look at it, but we have no real idea what the cause is. Can you suggest a direction or idea?

View Answer   |  Jun 30 2008   7:31 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server, SQL Server errors, SQL Server performance

disk activity is running at 100%

24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

View Answer   |  May 15 2008   2:52 AM GMT   |  asked by Salmonthefish
SQL Server administration, SQL Server performance, SQL Server security

load balancing in sql server

Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

View Answer   |  Apr 28 2008   11:08 AM GMT   |  asked by Rabinarayan
SQL Server clustering, SQL Server performance, SQL Server 2005

Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?

View Answer   |  Apr 4 2008   1:46 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server upgrades, SQL error messages, SQL Server performance

Flush the query plan from the RAM.

Our clients are reporting that the sql server is slowing down over a period of time. Once the SQL Server is restarted everything is fine.SQL server slowing down over a period of time though has technical reasons. SQL server caches (in memory) the queries that are sent it to, expecting to reuse it...

View Answer   |  Mar 27 2008   2:57 PM GMT   |  asked by MNA
caches, RAM, Query plan

Can SQL Server 2003 provide CPU usage information by application?

I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and it does not...

View Answer   |  Mar 21 2008   8:39 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2003, CPU usage, SQL Server performance

SQL Server - I would like a stored procedure that will take the name of a table as input.

I would like a stored procedure that will take the name of a table as input.What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops.Then I would like another stored procedure that takes a table name as...

View Answer   |  Mar 18 2008   3:18 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance, SQL Server, Stored procedures

Design a SQL Server trigger to calculate column averages and return them to another table

I'm quite new to SQL Server and I’m struggling to design a trigger. I need this trigger to execute daily and calculate averages of columns and return them to another table.

View Answer   |  Mar 16 2008   10:25 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance, SQL Server development, Triggers