Search Results | SQL Server Performance Forums

3GB Memory & Windows Server 2003 Standard Edition - Interesting question & Valueable insight on resolution

Post by: vipulkumar25, Jun 6, 2008 in forum: SQL Server Knowledge Sharing Network (SqlServer-qa

Can you also provide the SQL Server Patch which you hav installed?

2 General Questions

Post by: vipulkumar25, Sep 19, 2007 in forum: SQL Server 2005 General DBA Questions

Here are the answers 1) How do you remove a file in a filegroup? You need to run following two commands and there should be more than one file in a...

backup strategy

Post by: vipulkumar25, Sep 19, 2007 in forum: Getting Started

thomas I am not disagreeing that 15 min t backup will not suffice, but there are chances that these two process will clash , in my senario i am also...

backup strategy

Post by: vipulkumar25, Sep 19, 2007 in forum: Getting Started

Hi thomas, In my case my db size was 400 GB and 700 transactions pers ec.(tps) were hitting the database. what is your system configuration ?...

backup strategy

Post by: vipulkumar25, Sep 19, 2007 in forum: Getting Started

Hi Thomas, I am agree on your point that we should take transactional backup after every 15min. , but if we increase the frquency then the chekpoint...

Replication question

Post by: vipulkumar25, Sep 19, 2007 in forum: SQL Server 2005 Replication

Hi hemant, If the table size is big then do you suggest snapshot replication will work properly? Reagrds, Vipul

Buffer Cache Hit Ratio

Thread by: vipulkumar25, May 28, 2005, 2 replies, in forum: Performance Tuning for DBAs

When I am running DBCC SqlPerf(lrustats) buffer cache hit ratio is coming more than 100. What is the reason of this