Search Results | SQL Server Performance Forums

Hardware Planning for DWH

Post by: mishrsk, Aug 24, 2010 in forum: SQL Server 2005 General DBA Questions

Hi Sonny, This is a very open ended question. You can google "SQL Server Sizing Tools" and get the recommendation from different vendors. It will...

What will be the write sequence of VLF?

Post by: mishrsk, Jul 13, 2010 in forum: SQL Server 2008 General DBA Questions

Thanks Satya, got the answer.

What will be the write sequence of VLF?

Thread by: mishrsk, Jul 13, 2010, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hello, Suppose I have 4 VLFs sequentially numbered VLF1, VLF2, VLF3 and VLF4 for one of my databases. Say VLF2 and VLF4 are active and VLF1 and VLF3...

cache use counts/sec - Drastic fall

Post by: mishrsk, Aug 10, 2009 in forum: General DBA Questions

Yeh, sure, no SQL Agent Jobs or replication. Why?

cache use counts/sec - Drastic fall

Post by: mishrsk, Aug 9, 2009 in forum: General DBA Questions

Not really. The application usage is a bit less (say 10%). In propertion, this does not satisfy the drastic fall in cache use counts/ses. Well.. can...

cache use counts/sec - Drastic fall

Thread by: mishrsk, Aug 7, 2009, 5 replies, in forum: General DBA Questions

Windows 2003 Ent, SQL 2000 Ent with SP4. The processor utilization fall from 25% to 8%, Batch requests per sec fell from 8K to 400 and cache use...

Database Health and capacity projection

Post by: mishrsk, Jun 5, 2009 in forum: General DBA Questions

Hi Mohammed, I have already evaluated this tool and in a process of buying it. The question is coming to my mind, what is the logic and counters they...

Database Health and capacity projection

Thread by: mishrsk, Jun 3, 2009, 3 replies, in forum: General DBA Questions

Hi, Can somebody give direction on the following please. I wish to quantify workload and throughput of my SQL Server box containing one user database...

UPDATE STATISTICS - Variable run time

Post by: mishrsk, Jan 26, 2009 in forum: General DBA Questions

Hi, I am running UPDATE STATISTICS @TABNAME WITH SAMPLE @PCT PERCENT for all user tables in a DB. For tables with row count more than 1million, @PCT...

UPDATE STATISTICS - Variable run time

Post by: mishrsk, Jan 12, 2009 in forum: General DBA Questions

Can anyone please answer the query? Many Thanks.

UPDATE STATISTICS - Variable run time

Post by: mishrsk, Dec 23, 2008 in forum: General DBA Questions

Hi Satya, Still I am not very convinced. If update statistics is putting a schema modification lock, why will it get slow for any insert/update...

UPDATE STATISTICS - Variable run time

Post by: mishrsk, Dec 23, 2008 in forum: General DBA Questions

Hi Satya, Thanks for the response. Sorry but have some more questions. I have captured the locking/blockings during the run time of the long running...

UPDATE STATISTICS - Variable run time

Post by: mishrsk, Dec 22, 2008 in forum: General DBA Questions

Hi Satya, Thanks for the response. We are using SQL 2000 and not 2005. Running stats for all the tables is not really a good idea and we have even...

UPDATE STATISTICS - Variable run time

Post by: mishrsk, Dec 22, 2008 in forum: General DBA Questions

Hi Satya, Thanks for the quick response. I am running the update statistics for all the tables in the database. The database is 285 GB and the...

UPDATE STATISTICS - Variable run time

Thread by: mishrsk, Dec 22, 2008, 11 replies, in forum: General DBA Questions

Hi, I am running UPDATE STATISTICS with SAMPLE 30 PERCENT for one of my databases. When I am running it in busy times, it's taking almost 3 times...

Update Stats with Full Scan

Thread by: mishrsk, Oct 2, 2008, 2 replies, in forum: Performance Tuning for DBAs

Hi, I am on SQL 2000 SP4 with latest SQL patches. I am running the UPDATE STATISTICS WITH FULL SCAN on all tables twice a week. The time taken on...