Search Results | SQL Server Performance Forums

SQL2000 Max memory used now what

Post by: bytehd, May 7, 2008 in forum: Performance Tuning for DBAs

those links are developer stuff i dont have access to the source client, so i cant control SELECT * etc But I can take baselines. What happens when...

SQL2000 Max memory used now what

Post by: bytehd, May 3, 2008 in forum: Performance Tuning for DBAs

yeah i know. Dell mobo actually maxes at 4x512 PC133 ECC for 2 gigs total for $600 from Crucial I think I need to watch profiler traces and indexes...

SQL2000 Max memory used now what

Post by: bytehd, May 2, 2008 in forum: Performance Tuning for DBAs

2000 STD

SQL2000 Max memory used now what

Thread by: bytehd, Apr 28, 2008, 7 replies, in forum: Performance Tuning for DBAs

I have an older Dell boxen with 2000 SVR SP4 with SQL 2000 SP4 Our app is getting slower as it ages and the mainboard cannot take more than 1GIG of...

Can't find great article by Joe Chang

Post by: bytehd, Jun 16, 2007 in forum: SQL Server 2005 Performance Tuning for Hardware

Google architects ignored all the existing/typical commercial offerings and designed something unique for their purposes. but shouldnt the Google...

Searches timing out

Thread by: bytehd, Jun 3, 2007, 7 replies, in forum: Please Tell Us What You Think

June 3, 7pm EST Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /forum/search.asp, line 349

Storage Performance Reference Architecture

Post by: bytehd, Feb 26, 2007 in forum: SQL Server 2005 Performance Tuning for Hardware

Thanks Joe. I will give these new versions a whirl.

Opteron vs Xeon preference??

Post by: bytehd, Feb 23, 2007 in forum: SQL Server 2005 Performance Tuning for Hardware

Best NOT to trust those underpaid hardware magazine types. Esp Toms, Anandtech and Hot Hardware. As usual, they test 10-15% of a market segment and...

Recommended Hardware Configurations for SQL Server

Post by: bytehd, Jan 10, 2007 in forum: Performance Tuning for Hardware Configurations

concerning the quads: Has anyone thought about 4 sockets vs 1 quad-core socket? The same memory and i/o pins on the QUAD cant go active at the...

Joe - What is Cache?

Post by: bytehd, Nov 8, 2006 in forum: SQL Server 2005 General DBA Questions

uhh yeah. I wondered if anyone is rushing to chuck their SQL Databases for this thing. I also noticed a lack of any TPC benchs for Cache.

Joe - What is Cache?

Post by: bytehd, Nov 7, 2006 in forum: SQL Server 2005 General DBA Questions

Dont really want the company line. Thats why I asked it here.

Joe - What is Cache?

Thread by: bytehd, Nov 6, 2006, 5 replies, in forum: SQL Server 2005 General DBA Questions

Tired of seeing these ads "The post-relational database" How come I don't see this product in the TPC top 1000?

SQL Server 2005 Parallel Execution Plans

Post by: bytehd, Oct 11, 2006 in forum: SQL Server 2005 Performance Tuning for DBAs

Thanks!

Storage Performance Reference Architecture

Post by: bytehd, Oct 10, 2006 in forum: SQL Server 2005 Performance Tuning for Hardware

I broke out your SQL into separate scripts and will test at home. 1) Create Script 2) In-Memory script 3) Pseudo-random IO script 4) Table Scan the...

SQL Server 2005 Parallel Execution Plans

Post by: bytehd, Oct 10, 2006 in forum: SQL Server 2005 Performance Tuning for DBAs

So, have you re-released all those tests on 2005? i have: QuantitativePerformanceAnalysis.ppt SQLConn_ParallelExecutionPlans_2.ppt and...

SQL Server 2005 Parallel Execution Plans

Thread by: bytehd, Oct 9, 2006, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Joe, are you going to update your Parallel Execution Query plan article for 2005?

Storage Performance Reference Architecture

Post by: bytehd, Oct 3, 2006 in forum: SQL Server 2005 Performance Tuning for Hardware

subscribed also id like to try it on SQL Server Everywhere too. just kidding.

Benchmarks

Post by: bytehd, Mar 22, 2003 in forum: Performance Tuning for DBAs

10,000 jobhunters in the usa cant wait to hear from the "new era" dba 'I don't care a whole lot about speed'

Benchmarks

Post by: bytehd, Mar 22, 2003 in forum: Performance Tuning for DBAs

As i figured... no response.

2 CPUs

Post by: bytehd, Mar 17, 2003 in forum: Performance Tuning for DBAs

Adding CPUs does not automatically mean the APP will use them. I remember these discussions back when Novell added SMP to Netware in 1993. Only IPX...