0
votes
1answer
29 views

SQL Server Hardware Config

i am an IT Consultant and take up projects for my clients for setting up complete IT infrastructure. I have a client who has been facing problem with their DATABASE, he is a retail distributor for ...
1
vote
0answers
48 views

My server is slower than the average user's computer, should I still offload Access queries to SQL Server? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Databases I have a database set up with MS Access 2007 front ends and an SQL Server 2005 back end. At the moment, ...
2
votes
0answers
130 views

Full Text Search query elapsed time varying wildly

Database Version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 ...
1
vote
4answers
1k views

High CXPACKET wait type in SQL Server even with MAXDOP = 1

I have always had a very high CXPACKET wait type, and I've been told that it stems from parallel processing, and I should keep MAXIMUM DEGREE OF PARALLELISM = (NÂș Processors / 4), or 1 in my case. ...
1
vote
2answers
229 views

SQL Server 2005 running at 97% CPU usage

How can I findout which statements are using the CPU?
0
votes
1answer
127 views

What is the performance impact of changing the DB Owner in SQL Server 2005?

If I have two accounts, where: both accounts have DBO level access (use the DBO schema to log in, and are part of the owner group) one of the accounts is listed as the "actual owner" both accounts ...
2
votes
2answers
185 views

benefits of periodic backup and restores on SQLServer

In the olden days when I used to use other database platforms, we were advised to back up and restore our databases periodically to improve performance. Common reasons were that a B & R would ...
7
votes
1answer
337 views

SQL Server 2005 Performance Audit

Do you guys have any good step by step type links for performing an SQL Server 2005 Performance Audit? Something like this link would be great but for SQL Server 2005.
1
vote
2answers
2k views

SQL Server not releasing Memory

I am using SQL Server 2005. I am running a job which processes around 100 K records. Job runs fine, it takes are 45 mins to execute, which is good. But after that job is processed, I can see ...
1
vote
2answers
122 views

Don't know what is updating ALL my stats - causing IO problems

Woke up this morning with a page that our cluster was down. It came back up right away. I found log error logs with entries about IO taking longer than 15 seconds. Our monitoring server had tried to ...
1
vote
6answers
319 views

What would cause a query being ran from SSMS on local box to run slower then from remote box

When I run a simply query such as "Select Column1, Column2 from Table A" from within SSMS running on my production SQL Server the results seems to take extremely long (>45Min). If I run the same query ...
1
vote
3answers
733 views

SQL Server file growth extremely slow

I have a database with a size around 100 GB, and I have serious problems expanding the size of the database. This is my setup: SQL Server 2005, Version 9.0.4035 OS: Windows Server 2003 SP2 x86 ...
1
vote
4answers
440 views

Hardware setup advice for SQL Server 2005

I'm currently having trouble with a database server for a DB with lots of small writes and a few in comparison big reads. Read performance is more important because people is involved, writes are ...
3
votes
1answer
864 views

Why won't SQL Server use an index seek when running a parameterized query?

When I execute the following query in SQL Server 2005 it uses an index seek, as verified by viewing the execution plan. SELECT * FROM Account WHERE Number = '123456789' But when I run the same ...
0
votes
1answer
657 views

Speeding Up MSSQL Snapshot Replication to SQLExpress Replica

I have a well-connected remote site that I'm delivering snapshots to twice-daily of certain tables. Snapshot replication is the only method that I can use based on the schema limitations of the ...
5
votes
2answers
6k views

Clustered indexes versus non-clustered indexes?

I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the ...
4
votes
5answers
4k views

What can cause long query durations without high resource usage?

In advance: sorry for the length of the question... unable to get the right balance between detail and brevity. We are having issues with the DB Server for our web application where queries that ...
0
votes
2answers
455 views

SQL Perfmon Trace: Wait for the Worker

I am trying to track down a sql issue with timeouts and am by no means a DBA, but i'm stuck with the job so i'll get it done. I've been running a trace on just about everything i can think of ...