Search Results | SQL Server Performance Forums

distribution server in grave peril

Thread by: daustinash, Apr 3, 2007, 2 replies, in forum: Performance Tuning for SQL Server Replication

I have a distribution server with the CPUs pegged at 100%. Every night between 3AM and 7:45AM, jobs running on the publisher create what I presume is...

Indexed view is not used

Post by: daustinash, Jan 30, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

ysfinks, The above article posted by satya is awesom. I read it last night and cut a data scrub from 2 hours down to 5 minutes using an indexed...

SP1 and Named Instance

Post by: daustinash, Dec 15, 2006 in forum: SQL Server 2005 General DBA Questions

Thanks ranjitjain. This seems to be pretty hidden info. A google search turns up nothing. I'll give it a try. daustinash dnash@verndale.com

SP1 and Named Instance

Thread by: daustinash, Dec 15, 2006, 4 replies, in forum: SQL Server 2005 General DBA Questions

I have a server running 2 instances of sql server 2005, the default, and 1 named instance.<br /><br />How do i apply sp1 to the named instance...

Test row width and redirect error rows

Thread by: daustinash, Oct 16, 2006, 0 replies, in forum: SQL Server 2005 Integration Services

I have a fixed width flat file with a row width of 1287. It has ~6 million rows and I want to import it using SSIS. The catch is that my client...

Transactional Replication - Pull Subscription Prob

Post by: daustinash, Aug 25, 2006 in forum: SQL Server 2005 Replication

Date8/24/2006 7:44:19 PM LogJob History (PULL-publishersql3-CPS-SystemTables-subscribersql3_CPS) Step ID1 Serversubscribersql3 Job...

Transactional Replication - Pull Subscription Prob

Thread by: daustinash, Aug 25, 2006, 4 replies, in forum: SQL Server 2005 Replication

Good morning, I am almost through my first attempt at configuring transactional replication in sql server 2005. My publisher is in the Northeast,...

Run SSIS Package on 2000 Database Server

Thread by: daustinash, Jul 26, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

I have a database running on Sql Server 2000 sp3. I also have a perfect opportunity to use SSIS to do a data bridge in this database. I know I can...

Real Life Performance Riddle. CPU 100% Yow!

Post by: daustinash, May 15, 2006 in forum: Performance Tuning for DBAs

I hear you joechang. That's what I'm afraid of, but a couple of things. 1. I didn't think about the fact that the server might only need 8192, and...

Real Life Performance Riddle. CPU 100% Yow!

Post by: daustinash, May 15, 2006 in forum: Performance Tuning for DBAs

I think you guys are right. I think the problem stems from poorly written queries against tables with very little to no useful indexing in poorly...

Real Life Performance Riddle. CPU 100% Yow!

Post by: daustinash, May 15, 2006 in forum: Performance Tuning for DBAs

I constantly get queries with durations between 1000 ms and 30000 ms. I get about 5-7% CPU durations over 100 ms too. daustinash dnash@verndale.com

Server wide performance problem. CPU 100%

Thread by: daustinash, May 15, 2006, 1 replies, in forum: Performance Tuning for DBAs

I have a database server that started red-lining at 95-100% processer usage sometime last week. I'd know for sure, but I'm not officially the dba...

Performance Degradation

Post by: daustinash, May 15, 2006 in forum: Performance Tuning for DBAs

qwerty88, SQL Server stores a chached query plan for stored procedures. It determines this best fit plan based on the nature of the data, and the...

Real Life Performance Riddle. CPU 100% Yow!

Thread by: daustinash, May 15, 2006, 17 replies, in forum: Performance Tuning for DBAs

This is just like a MCDBA exam question, just not multiple choice. I have a database server that started red-lining at 95-100% processer usage...