Search Results | SQL Server Performance Forums

Could not find stored procedure 'sp_MSdel_dboSessionContextNames'.mssqlserver error 2812

Thread by: tariq745, Aug 17, 2010, 8 replies, in forum: SQL Server 2008 Replication

Hello I am replcating data (tables only) from SQL Server 2000 (SP3a) to SQL Server 2008 (SP2). Everything work fine I dont get any error copies the...

Is this Normal (where to start) Slow for Crystal Users

Thread by: tariq745, Jan 21, 2009, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

HiI have SQL Server 2005 enterprise edition running on Xeon CPU (4 processors) with 8GB ram. Antivirus Symantec also running on the same box as SQL...

Logon failed SSPI context and Crystal Report

Thread by: tariq745, Mar 26, 2008, 2 replies, in forum: General DBA Questions

I am trying to connect to crystal report 9 I get this errorLogon FailedDetails: ADO Error Code: 0x80004005Source: Microsoft OLE DB Provider for SQL...

Schedule DTS/SSIS

Thread by: tariq745, Jan 15, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

I imported dts from SQL Server 2000 to 2005 and they run fine without any problems. I want to find out if there is a way I can schedule sql 2000 dts...

Bulk Copy

Thread by: tariq745, Dec 21, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi Is there anything like Slow and Fast bulk copy in SQL Server 2005 (ENT edition)? I am using DataMirror software to replicate data from DB2 to SQL...

Help 911 Server Running Slow but CPU activity is low??

Thread by: tariq745, Dec 6, 2007, 1 replies, in forum: Performance Tuning for DBAs

Hi I am running SQL Server 2000 (ent edition) on windows 2003. My server is running slow but task manager shows that cpu performance is low, like...

Index?

Thread by: tariq745, Oct 25, 2007, 4 replies, in forum: Performance Tuning for DBAs

I have 2 questions1) One big index performs better then 2 small indexes or the opposite?2) I have table with 17242772 rows and I have index1 and...

Find Indexes and their size

Thread by: tariq745, Oct 10, 2007, 5 replies, in forum: General DBA Questions

Hi Can anyone tell me how can I find how many indexes I have in my database and what's their size? I am using SQL Server 2000 (Ent Edition). Thanks

CPU Time and Memory Usage

Thread by: tariq745, Oct 4, 2007, 4 replies, in forum: Performance Tuning for DBAs

Hi guysJust want to ask, my SQL box task manger showing that SQLservr.exe is using 1.3gb of memory and its CPU time is 24:15:27. System idle process...

Can it be done?

Thread by: tariq745, Sep 19, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

I am searching if transactional replication can be setup from DB2/AS400 (as publisher) to SQL Server enterprise edition (as a subscriber) without...

Replication from DB2 to SQL Server 2005

Thread by: tariq745, Aug 17, 2007, 13 replies, in forum: SQL Server 2005 Replication

I have to replicate data from IBM DB2 on AS/400 to SQL Server 2005. Is that doable? Currently we are replicating data from DB2 to SQL Server 2000...

Upgrade Advisor Sql server 2005 (DTS)

Thread by: tariq745, Aug 15, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

I ran the upgrade advisor and it gave me two warrning1) SQL Server 2000 Meta Data Services packages are not supported2) SQL Server 2000 DTS designer...

Trace one SP

Thread by: tariq745, Jun 22, 2007, 1 replies, in forum: Performance Tuning for DBAs

My CPU is going upto 90%.I found the SP which is taking the longest time. Can anyone tell me how can I open a trace for only one SP to see what its...

default filegroup is full

Thread by: tariq745, May 24, 2007, 14 replies, in forum: Performance Tuning for DBAs

Hi Guys<br />I am getting the flowing error when I am trying to run a job which moves data. I am running sql server 2000, sp 3a, I have 4 files in...

CPU 100 usage (Help)

Thread by: tariq745, Feb 16, 2007, 14 replies, in forum: Performance Tuning for DBAs

I am having problems with CPU usage its going up and down from 30% 100%. There are 2 jobs running one see if there new data came from the client put...

Backup & Performance

Thread by: tariq745, Feb 13, 2007, 1 replies, in forum: Performance Tuning for DBAs

Hi I am new to SQL Server. We are using SQL Server 2000 (standard edition) currently the DB is 7 GB and we do full backup every night with SIMPLE...

Backup & Performance

Thread by: tariq745, Feb 13, 2007, 6 replies, in forum: General DBA Questions

Hi I am new to SQL Server. We are using SQL Server 2000 (standard edition) currently the DB is 7 GB and we do full backup every night with SIMPLE...