Search Results | SQL Server Performance Forums

Insufficient Memory Alert

Thread by: seanlo@jdg.co.za, Jan 31, 2007, 6 replies, in forum: Performance Tuning for DBAs

Hi There I am a bit stumped. I have a SS2000 enterprise Edition instance. Up until 2 days ago it had performance issues, related directly to huge...

data files across LUN's

Thread by: seanlo@jdg.co.za, Oct 17, 2006, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi There I know for parttioning or just general filegroup administration etc, it is best practice to split your data files on seperate disks, same...

DTA only works for simple queries?

Thread by: seanlo@jdg.co.za, Oct 9, 2006, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi There Is anyone else experiencing problems with DTA when query tuning? Basically DTA only works is i try tune a very simple query, like a simple...

VLDB management

Thread by: seanlo@jdg.co.za, Oct 9, 2006, 12 replies, in forum: SQL Server 2005 General DBA Questions

Hi There I have an OLTP DB currently at 50Gig. In a short period of time this will grow to at least a terrabyte. I am already looking into...

How can you tell if sql server is using memory?

Thread by: seanlo@jdg.co.za, Oct 4, 2006, 1 replies, in forum: SQL Server 2005 General DBA Questions

HI There I have a server running Sql Server 2005 Standard Edition X64. There are 3 instances on this server. The server has a total og 16Gig Ram, i...

Distributed App, Technology Question ?

Thread by: seanlo@jdg.co.za, Jul 20, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi Everyone. I am trying to get ideas for a possible technology we could use for a certain scenario. In a nutshell we want to run a distributed...

Sql Server 2005 64 bit

Thread by: seanlo@jdg.co.za, Jul 13, 2006, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi There I am having trouble finding out if there are any special considerations for Sql Server 2005 64 bit. BOL is useless, basically i need to...

Yes more cursor questions ??

Thread by: seanlo@jdg.co.za, Apr 10, 2006, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi I have been able to find this default cursor behaviour in BOL. So if anyone can take the time to answer these thank you very much: These...

sp_cursorexecute , actual sql ?

Thread by: seanlo@jdg.co.za, Apr 10, 2006, 1 replies, in forum: T-SQL Performance Tuning for Developers

Hi Guys I pick up the following in a profiler trace. exec sp_cursorexecute 197, @P1 output, @P2 output, @P3 output, @P4 output,...

How to without a cursor ?

Thread by: seanlo@jdg.co.za, Apr 10, 2006, 11 replies, in forum: T-SQL Performance Tuning for Developers

Hi There I have a table: Table A ======== Column 1 Column 2 Column 3 Another Table B ======== Column 1 Column 2 Column 3 Column 4 Simplifying the...

High cpu utilization

Thread by: seanlo@jdg.co.za, Apr 5, 2006, 6 replies, in forum: Performance Tuning for DBAs

HI There I am in need of some high cpu sql statements tips. I have been performance optimizing and baselineing for a while, but i am a bit stumped...

Distributed Transactions

Thread by: seanlo@jdg.co.za, Mar 27, 2006, 2 replies, in forum: General Developer Questions

Hi There I realize this is probably a basic question or at least i hope so but i cannot get distributed transactions working. BOL is just driving...

Update Stats

Thread by: seanlo@jdg.co.za, Mar 16, 2006, 4 replies, in forum: General DBA Questions

Hi There Is there any need to manually update stats during maintenance jobs at night if the database is set to auto update stats ? Thanx

encryption require to connect to msdb packages

Thread by: seanlo@jdg.co.za, Mar 15, 2006, 4 replies, in forum: SQL Server 2005 Integration Services

Hi There I am using SS2005 Enterprise Edition, proper release version not a ctp or anything When i try navigate to my packages in MSDB i get the...

side by side migration sql server 2000 db to 2005

Thread by: seanlo@jdg.co.za, Mar 13, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi There Does any one have a good resource or link on the side by side migration process and considerations for migrating a sql server 2000 database...

Insert without a cursor ?

Thread by: seanlo@jdg.co.za, Feb 28, 2006, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi There This is probably an old often asked question. I need to do the following: INSERT INTO TABLEA (COLUMN LIST) SELECT (COLUMN LIST) FROM...

Perfmon cannot add sql counters

Thread by: seanlo@jdg.co.za, Feb 20, 2006, 3 replies, in forum: Performance Tuning for DBAs

Hi There When i setup a perfmon trace on a server for normal server counter, processor, physical disk etc everything is ok. As soon as i add any...

SS2000 Memory Monitoring/Optimizing

Thread by: seanlo@jdg.co.za, Feb 6, 2006, 3 replies, in forum: General DBA Questions

HI There I have various scripts and profiler templates that help me track cpu and io usage. To find out which queries are using the most cpu and...

SPID that wont die

Thread by: seanlo@jdg.co.za, Jan 29, 2006, 1 replies, in forum: General DBA Questions

Hi There The other day i was testing a new backup script that deleted old backups etc. For some unknown reason 9 hours later the job was still...

Replication agent failure alert

Thread by: seanlo@jdg.co.za, Jan 25, 2006, 5 replies, in forum: General DBA Questions

Hi There Ok hopefully this is a simple question. Under replication monitor on a distributor, under replication alerts, i have enabled the...