Search Results | SQL Server Performance Forums

Performence counter in 2005

Thread by: snarayanas, Dec 15, 2006, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all, I have noticed that buffer cache hit ratio on sql 2005 instance showing 0 values why? siri Swamy Sirigineedi

Single user mode in 2005

Thread by: snarayanas, Dec 13, 2006, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi experts, How do i take my instance in single user mode in sql 2005? Any idea, Is any body performed rebuild master database? Swaamy Swamy...

Index management 2005

Thread by: snarayanas, Dec 12, 2006, 3 replies, in forum: SQL Server 2005 General DBA Questions

I heard that we can perform online index rebuild activity on SQL 2005. Did any one performed this? Where exactly it differs from sql2000. if you...

Replication on different versions

Thread by: snarayanas, Sep 26, 2006, 1 replies, in forum: Performance Tuning for SQL Server Replication

Is it possible to set up replication between an SQLServer Enterprise edition ( publisher ) and SQLServer Standard edition ( subscriber ), or do both...

Analysis services account

Thread by: snarayanas, Sep 19, 2006, 2 replies, in forum: Analysis Services/Data Warehousing

Hi , For installation of Analysis services whether domain account/ local system account can be used for start the services. Regards, Swamy

Building Servers

Thread by: snarayanas, Aug 22, 2006, 1 replies, in forum: Performance Tuning for Hardware Configurations

Hi All, Can you suggest for building new server hardware configurations. Server Model Number of processors Type of processor Memory 32-bit or...

Cluster Question

Thread by: snarayanas, Jun 26, 2006, 2 replies, in forum: General DBA Questions

SQLDBA's, I want small clarification when we implement Active/Active cluster, i belive there are 2 virtual servers virt1 and virt2,instance inst1...

Uninstall Named instance

Thread by: snarayanas, Jun 26, 2006, 2 replies, in forum: General DBA Questions

Hello All, I want to uninstall Named instance. can you suggest best way. I did not find named instance name in add remove programs. -Regards,...

cluster requirements

Thread by: snarayanas, May 29, 2006, 2 replies, in forum: General DBA Questions

Hello, To install MS-cluster services on my LAN what are the requirements. NS

Moving Sp's XSp's

Thread by: snarayanas, May 8, 2006, 5 replies, in forum: General DBA Questions

I want to move MASTER database sp and xsp's to another server Master database. Is there any way to transfer them. -NS

Backup fail issue

Thread by: snarayanas, Apr 24, 2006, 3 replies, in forum: General DBA Questions

Hi all, My database size is around 8 GB. I have sufficient space on my shared backup drive. even though my backup's getting failed. In the SQL...

dead lock

Thread by: snarayanas, Apr 23, 2006, 3 replies, in forum: General DBA Questions

Hello All, Below are i am getting from Application side, can i know the reason. Is it application error or database issue. Please let me know....

Reporting services on SQLServer 2000 client

Thread by: snarayanas, Mar 15, 2006, 2 replies, in forum: SQL Server Reporting Services

Hello All, Can i install reporting services on SQL2k client machine? Swamy

CUSTOME ALERTS SQLDM

Thread by: snarayanas, Jan 31, 2006, 1 replies, in forum: General DBA Questions

HELLO Experts, Can we schedule custom script in SQLDM, if any one doing any operations to that database can we get alert? NS

Active/Active cluster

Thread by: snarayanas, Jan 29, 2006, 1 replies, in forum: General DBA Questions

Hello Experts, Can you explain me active/passive and active/active clusters. NS.

Log file more than DB size

Post by: snarayanas, Jan 25, 2006 in forum: General DBA Questions

Recovery mode is Full

Log file more than DB size

Thread by: snarayanas, Jan 25, 2006, 4 replies, in forum: General DBA Questions

Suddenly my Log file has grown 100 time than my DB size. Application side some issues due to this my log has grown to 100 GB where as my DB size is 1...

SQL2005 error

Thread by: snarayanas, Jan 4, 2006, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hello All, I have installed SQL Server 2005 on two machines i want to implement MIRROR. When I am trying to register MIRROR server on PRINCIPAL. I...

4 node cluster sp4 installation

Thread by: snarayanas, Dec 13, 2005, 1 replies, in forum: SQL Server Clustering

We have a 4-node 3-instance cluster running SQL Server 2000 SP 3a. We want to install Service Pack 4 and also configure AWE. Could you tell me how...

SP4 on Active/Passive Failover cluster

Thread by: snarayanas, Nov 15, 2005, 1 replies, in forum: SQL Server Clustering

Hello All, I am planning to install on SQLServer 2000 Service pack4 active/passive mode on windows 2000 advanced server.Please let me know how to...