Search Results | SQL Server Performance Forums

Clustering with Remote based mirroring support help

Thread by: Ebenraja, Apr 21, 2011, 2 replies, in forum: SQL Server 2008 Clustering

One of my recent requirement is to provide my client with an 100% high availability solution for SQL Database. Thinking about proposing a Clustering...

Mechanism to alert DBA when a SQL scheduled job runs for a long time in SQL2005

Thread by: Ebenraja, Nov 1, 2010, 7 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, There is some problems with some of my SQL jobs related with netbackup strergy and applicational pakages as well, that run on sometime quite...

Tempp DB performance - Processor count

Thread by: Ebenraja, Feb 10, 2010, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hello All, I do have a database whose size is to the tune of 196 GB, the database has around 28 file groups (one primary and rest ndf files); almost...

Automate Job to Kill process that heavily accces the SQL machine

Thread by: Ebenraja, Oct 29, 2009, 2 replies, in forum: General DBA Questions

Hello friends, I do have a 'SQL user' who runs a lot of queries that causes performance issues to the database machine. I want to write a query that...

Help to move heavily acessed table to a new file group

Thread by: Ebenraja, Sep 9, 2009, 1 replies, in forum: General DBA Questions

Hi All, Would highly appreciate if any of you can help me with the following as a part of increasing the performance in the database. I want to find...

Target server status shows as Nomral blocked in Manage target server status

Thread by: Ebenraja, Jul 7, 2009, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have configured backups through Master target server concept. I have added 8 servers as target servers to my master server. these target...

Stack dump error and SQL service gets restarted daily

Thread by: Ebenraja, May 26, 2009, 7 replies, in forum: General DBA Questions

All, Please help me with this problem i face... I am using a SQL7.0 version server and recently for the past 1 week my SQL related services goes for...

SQl server gets Restarted when i run the DBCC Check table command

Thread by: Ebenraja, Mar 31, 2009, 5 replies, in forum: General DBA Questions

Hi All, I am facing a situation where my SQL server gets restarted often. There are 2 drives in the server and the System team had run check disk...

Are there any flawsproblems in SQL2008 that you have come across till date

Thread by: Ebenraja, Mar 8, 2009, 8 replies, in forum: SQL Server 2008 General DBA Questions

All, I am in the process of submitting a request to my client to upgrade my SQL2000 to SQL2008 ,I want to know the list issuesproblems or flaws in...

Anybody have any ideas if MS SQL 7.0 is compatable with Windows Server 2003?

Thread by: Ebenraja, Mar 8, 2009, 1 replies, in forum: General DBA Questions

All, Can anyone kindly let me know if MS SQL 7.0 is compatable with Windows Server 2003? Regards, Eben

SQL 2000 database often gets back to rollback state

Thread by: Ebenraja, Dec 8, 2008, 3 replies, in forum: General DBA Questions

Hi, I have a SQL 2000 database of size around 100 GB set in Simple recovery mode facing the following issues often The database backup process...

Index defragmentation Query please...

Thread by: Ebenraja, Oct 13, 2008, 9 replies, in forum: SQL Server 2005 General DBA Questions

Hello All, I am in the process of configuring database maintenance plans which include (Update Statistics,Update Usage, Indexdefrag,Check DB,Check...

Windows domain group authentication failed

Thread by: Ebenraja, Sep 26, 2008, 1 replies, in forum: General DBA Questions

I have created a dmoan called prodappaccess and added my prod amesh id to the group prodappaccess. the group prodappaccess has been added to the sql...

Is Active directory required to implement Mirroring and Log shipping.

Thread by: Ebenraja, Sep 25, 2008, 2 replies, in forum: General DBA Questions

Hi, Please let me know if Active directory is required to implement Mirroring and Log shipping. If yes please let me know why too....

Temp db gets filled up fast

Thread by: Ebenraja, Sep 25, 2008, 3 replies, in forum: General DBA Questions

Hi All, I have a SQL 2000 server where i currently face a Tempdb issue, i have a dedicated drive for the tempdb alone for around 54 GB, the drive...

Multi server Administration -Maintenance plan job configuration

Thread by: Ebenraja, Sep 8, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi,I have a master SQL2005 server and i have added target servers to my master server. The problem is this.I configured backup jobs(in form of...