Search Results | SQL Server Performance Forums

Too many timeouts and error establishing connectio

Thread by: exBK, Feb 27, 2007, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Our Prod SQL 2005 server is experiencing timeouts and error establishing connection errors. This is happening ever since more people are using the...

setting up database mirroring

Post by: exBK, Mar 7, 2006 in forum: SQL Server 2005 Database Mirroring

quote:Originally posted by indigomirage Thanks for the reply! By numbers, are you referring to port numbers? If so, then this is already the case....

Database Tuning Advisor

Thread by: exBK, Feb 1, 2006, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I am not able to get my DB Trace analyzed through the Tuning Advisor. Here is what I am doing ... I create a new trace. Capture activities for 30...

SQL 2005 Cluster Setup question.

Post by: exBK, Dec 2, 2005 in forum: SQL Server 2005 Clustering

My goal is to setup a development environment with SQL 2005 Cluster. Also would like to explore the Cluster features and how they are setup. The...

SQL 2005 Cluster Setup question.

Thread by: exBK, Dec 1, 2005, 3 replies, in forum: SQL Server 2005 Clustering

I would like to setup SQL 2005 clustering. I am not sure what all I need to have ... I have a Windows 2003 Enterprise Server with multiple VM's on...

SQL 2005 Cluster

Post by: exBK, Dec 1, 2005 in forum: SQL Server Clustering

Sorry I tried to edit and I don't get an option to move to 2005 forum. If you can plesae delete this message and I will post it again in 2005 forum....

SQL 2005 Cluster

Thread by: exBK, Dec 1, 2005, 3 replies, in forum: SQL Server Clustering

Is it possible to set-up a SQL Cluster on a Virtual Machine running Windows 2003 just for testing purpose and playing with Cluster installation?...

How to convert a SQL 2000 DB

Post by: exBK, Nov 22, 2005 in forum: SQL Server 2005 General DBA Questions

Thanks that worked!

How to convert a SQL 2000 DB

Post by: exBK, Nov 22, 2005 in forum: SQL Server 2005 General DBA Questions

They are SQL users.

How to convert a SQL 2000 DB

Thread by: exBK, Nov 21, 2005, 5 replies, in forum: SQL Server 2005 General DBA Questions

I would like to move a SQL 2000 DB to SQL 2005 Enterprise Edition. My SQL 2000 DB already has a few users in it. When I do a full-backup in 2000...

DELETE is running very slow

Post by: exBK, Nov 15, 2005 in forum: T-SQL Performance Tuning for Developers

So what will the delete statement look like? I tried: DELETE FROM tableX WHERE quest_country='US' and quest_year=2004 WITH (INDEX(0)) and it didn't...

DELETE is running very slow

Thread by: exBK, Nov 15, 2005, 4 replies, in forum: T-SQL Performance Tuning for Developers

I have a table which has about 80,000 records. Table has a composite key of quest_id, quest_country and quest_year. When I run a delete statement:...

Log size reduction

Post by: exBK, Jan 11, 2005 in forum: General DBA Questions

Thanks a lot. That was exactly what I needed !!!

Log size reduction

Thread by: exBK, Jan 11, 2005, 2 replies, in forum: General DBA Questions

Hi, I have gone through the forum and read a few posts on this issue. I am still having the problem: My DB is about 600 MB and Log is about 2GB. I...

Where do I start - Performance Quest

Thread by: exBK, Mar 8, 2004, 5 replies, in forum: T-SQL Performance Tuning for Developers

Sometimes, the server on which my DB resides starts slowing down. At that point, the CPU is at constant 100%. After a while (usually 2-4 hours...

Table Size/Performance

Thread by: exBK, Mar 2, 2004, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi, We have a User table that contains close to 10 million rows of data. We expect it to grow by atleast a million rows per month. For each user,...