Search Results | SQL Server Performance Forums

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

Post by: Narine, Dec 2, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs

Unfortunetely, we haven't resolved the issue. We've upgraded to 2008, and the problem did not go away. Recenly, I stumbled upon the following post...

Only one CPU core is maxed out

Post by: Narine, Jul 13, 2009 in forum: SQL Server 2008 Performance Tuning for DBAs

Thanks for the reply, Luis. It's got AMD Opteron /2.60GHz.

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

Post by: Narine, Oct 22, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

Thanks so much for the info ot tuning, gurucb! In our environmnet none of this is true. Compilations are much smaller than Batches/sec and...

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

Post by: Narine, Jun 18, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

Thank you for the suggestion! How would you suggest paritioning it? Also we're using SQL2K5 Standard edition. Isn't automatic partitioning available...

How to tune query on a table with Text columns

Post by: Narine, Jun 11, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

Thanks you for the reply! The search criteria always includes UserID of the user viewing his email. I was finaly able to convince my manager to...

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

Post by: Narine, May 29, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

HI Satya, We're SP2 Cumulative Update 5. Thanks

CPU is low when Profiler is running

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

Thanks, Luis. I never used this counter before. So before I run the Profiler, Average process-->sqlsrv %time is 240. Once Profiler is started it...

CPU is low when Profiler is running

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

Luis, I went back and forth between the Task Manager and the Performance Monitor to watch CPU Thanks Narine

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

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

Thanks Alen for the reply. I just found a problem in my code. THe ListingId is a varchar field and I wasn't using quotes around my parameter in the...

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

Post by: Narine, Feb 6, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

It's got SP2 and Cumulative Update 2 on it. Thanks for the link. According to this article, post SP2 Cumulative Update 5 should fix the problem....

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?

Post by: Narine, Dec 27, 2007 in forum: SQL Server 2005 Performance Tuning for DBAs

Thanks a bunch, Greg! This is exactly what I was looking for!

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