Search Results | SQL Server Performance Forums

Only one CPU core is maxed out

Thread by: Narine, Jun 22, 2009, 4 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hi experts, We've got 2-dual core AMD processor server running SQL server 2005 Standard SP3. OS is Windows 2003 Enterprise SP2. Only one CPU core is...

32-bit SQL Server 2005 Standard running on 64-bit processor server

Thread by: Narine, Oct 14, 2008, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, I'm looking for some advice. We currently have a 32-bit SQL server 2005 Standard edition running on a 32-bit processor server with 2...

Full Text Search is slow only for certain words

Thread by: Narine, Oct 7, 2008, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, We have a Full Text Search setup on one of the tables in the SQL Server 2005 database. It works fine for most of the cases, returns results...

How to tune query on a table with Text columns

Thread by: Narine, Jun 10, 2008, 6 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi everone, We are using SQL 2005. We've got an email table that holds all our customers emails. Needless to say, it's very big, currently 4.5 mil...

CPU is low when Profiler is running

Thread by: Narine, May 23, 2008, 8 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, I've observed a very strange occurance on our SQL Server 2005 server. This server has a CPU bottleneck, CPU usage is between 80-95%...

How to get rid of the Clustered Index Scan

Thread by: Narine, May 22, 2008, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, I have a table with 32 million rows. It has a clustered index on a non-unique column, ListingID. WHen I select from the table searching on a...

Improving performance on a very large table

Thread by: Narine, Feb 13, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, We are using SQL2K5 Standard 32Bit. We've got a very large table that contains user emails with a few Text columns for Email Body, Email To...

Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources and could not produce a query plan

Thread by: Narine, Feb 5, 2008, 8 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, We're getting the following error intermittently on one of our SQL2K5 servers: Error: 8623, Severity: 16, State: 1.The query processor ran...

How to monitor transaction activity between the databases?

Thread by: Narine, Dec 21, 2007, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi Everyone, Our real estate application runs on 23 databases split by property listings regions. Other than user property searches, there are C#...

Timeouts when Database Backup is running

Thread by: Narine, Dec 12, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

HI all, Is there a known issue in SQLL2K5 with backups needing more resources than in SQL2K? Our users seem to be getting time outs at night when the...

Memory Problem on SQL Server 2000

Thread by: Narine, Oct 11, 2007, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi All, One of our systems is still on SQL2K Enterprise Edition under Win2K3 Enterprise Edition. Server has 8GB of RAM. After reading the article...

Memory usage in SQL Server 2005

Thread by: Narine, Oct 5, 2007, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi everyone, We have a SQL Server 2005 Standard edition under Win2K3 server. What is a maximum memory SQL Server can use in this case? We have 8GB of...

Profiler Filter doesn't seem to work

Thread by: Narine, Oct 4, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi everyone, We have a table in SQL 2K5 that mysteriosuly gets data deleted from every so often. I wanted to capture the culprit and have setup a...

Full Text Search Not working as expected

Thread by: Narine, Sep 27, 2007, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, I'm new to using a Full Text Search. We have a web and database based Email application, and our users need to be able to search for their...

Clearing Cache

Thread by: Narine, Sep 13, 2007, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, I'm trying to tune a query in SQL Server 2005. The query takes in a User ID as a parameter. Initially, the query takes around 2 minutes to run...