Search Results | SQL Server Performance Forums

Execute SSIS from Sproc

Thread by: fullomschf, Apr 11, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

I need to convert several DTS packages to SSIS...the migration wizard just doesn't do 100% of what I need...and I'm totally lost<img...

Storing Perfmon data

Post by: fullomschf, Sep 9, 2005 in forum: Performance Tuning for DBAs

How do you perform trend analysis and forecasting without storing historical data?

Storing Perfmon data

Thread by: fullomschf, Sep 8, 2005, 3 replies, in forum: Performance Tuning for DBAs

Hi all, I have a somewhat unique scenario, where I collect perfmon stats on one network (Production) then copy the results to another network...

Summarizing Performance Stats

Post by: fullomschf, Aug 1, 2005 in forum: Performance Tuning for Hardware Configurations

Our memory setting is not dynamic (AWE enabled), however my question has...

Summarizing Performance Stats

Post by: fullomschf, Jul 29, 2005 in forum: Performance Tuning for Hardware Configurations

I was thinking more along the lines of this example: Total Server Memory: 7179816 If I have 8GB of memory...how can I show this as a percentage of...

Summarizing Performance Stats

Thread by: fullomschf, Jul 29, 2005, 4 replies, in forum: Performance Tuning for Hardware Configurations

Newbie Question... I have collected perfmon stats in a .csv file (stat collected every 15 seconds). I am using Excel to analyze the results,...

Intra-query parallelism error

Thread by: fullomschf, Jul 19, 2005, 2 replies, in forum: Performance Tuning for DBAs

I searched this site for an answer to the error message: Intra-query parallelism caused your server command (process ID #1322) to deadlock. Rerun...

Sproc & Table Locks

Post by: fullomschf, Jul 12, 2005 in forum: Performance Tuning for DBAs

Thank you very much...your suggestions were very helpful.[<img src='/community/emoticons/emotion-2.gif'...

Lock:Released - ObjectID = 0

Thread by: fullomschf, Jul 12, 2005, 2 replies, in forum: Performance Tuning for DBAs

I'm noticing several hundred entries in a profiler trace for Lock:Released, ObjectId = 0. Does anyone know why ObjectId = 0 would occur?

Sproc & Table Locks

Post by: fullomschf, Jul 8, 2005 in forum: Performance Tuning for DBAs

--CREATE PROC MergeContacts @iLocationint, @iFromContactId int, @iToContactId int, @dtUpdateDate datetime As BEGIN...

Sproc & Table Locks

Post by: fullomschf, Jul 7, 2005 in forum: Performance Tuning for DBAs

All the noted performance steps have been put in place. Just running this sproc for one or two records creates and extremely large amount of RID and...

Sproc & Table Locks

Thread by: fullomschf, Jul 7, 2005, 6 replies, in forum: Performance Tuning for DBAs

I recently transistioned from a primarily OLAP environment to a high...