Search Results | SQL Server Performance Forums

UMS Scheduler Hang

Post by: smounkhaty, Apr 11, 2006 in forum: General DBA Questions

Luis, There has been a lot of talking that applying SP4 is far from certain to fix the issue. What about turning on max degree parallelism? My...

UMS Scheduler Hang

Thread by: smounkhaty, Apr 10, 2006, 4 replies, in forum: General DBA Questions

Hi Guru, Our HR sql 2000 production server is 800.760 built (SP3a) with 2GB of RAM and 2 CPU hiper threading. This server is very low activity where...

DB mirroring Setup

Thread by: smounkhaty, Apr 4, 2006, 1 replies, in forum: SQL Server 2005 Database Mirroring

Hi Guru, Please help!!! SQL 2005 Standard/Windows 2003 R2 Servers not in domain environment but they are in DMZ zone. SQLSERVICE runs on...

sp_dropalias

Thread by: smounkhaty, Jan 12, 2006, 2 replies, in forum: General DBA Questions

Hi Guru, One of my SQL 2000 box(marketing) has login named reportUser. This reportUser has sysadmin rights in the marketing server. There is a...

Lost Data

Post by: smounkhaty, Dec 19, 2005 in forum: General DBA Questions

Luis, I did not explain more clearly. The database that I lost data was from SQL Server2000 standard version with Win2000. In other words, the new...

Lost Data

Thread by: smounkhaty, Dec 19, 2005, 5 replies, in forum: General DBA Questions

Hi Guru, This weekend, I migrated SQL Server7.0 to 2000 and below is the scenarios: 1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL)...

DBCC INDEXDEFRAG

Thread by: smounkhaty, Dec 1, 2005, 1 replies, in forum: Performance Tuning for DBAs

Hi Guru, One of my vendor database has about 500 tables where owner not belong to dbo. I'm having a hard time to do online defrag from M-F because...

PAGEIOLATCH is a lead blocker

Post by: smounkhaty, Nov 30, 2005 in forum: Performance Tuning for DBAs

Luis,<br /><br />This is peoplesoft vendor applicaiton. Data manipulation is done in application itself. I'm having a very hard time to capture long...

PAGEIOLATCH is a lead blocker

Post by: smounkhaty, Nov 30, 2005 in forum: Performance Tuning for DBAs

All, I don't see any memory issues on this server because I just added 2GB of RAM not long ago. Buffer Cache Hit Ratio constanly runs average 99.8%....

PAGEIOLATCH is a lead blocker

Thread by: smounkhaty, Nov 29, 2005, 6 replies, in forum: Performance Tuning for DBAs

Hi Guru, After spening quite sometimes to watch my box, I've seen PAGEIOLATCH is a lead blocker in my SQL Server 2000 server. Below is the detailed:...

API Cursors

Thread by: smounkhaty, Nov 21, 2005, 1 replies, in forum: Performance Tuning for DBAs

Hi Guru, My company, every thing we need is to buy from a vendor. However, we have PEOPLESOFT CRM app that has around 6000 tables and around 5000...

HIT and MISS

Post by: smounkhaty, Nov 17, 2005 in forum: Performance Tuning for DBAs

Luis,<br /><br />I don't think it's necessary to include all data columns because I just wanted to see sp:cachemiss and eventclass, textdata, loginID...

HIT and MISS

Post by: smounkhaty, Nov 17, 2005 in forum: Performance Tuning for DBAs

Luis, Microsoft SQL Server 2000 - 8.00.760 Build. Thanks, Silaphet,

HIT and MISS

Thread by: smounkhaty, Nov 17, 2005, 4 replies, in forum: Performance Tuning for DBAs

Hi Guru, My profiler trace does not display SP:CACHEMISS event, even thought I drop store proc, clear both data cache and buffer cache but still...

Defragment Heap Tables

Thread by: smounkhaty, Oct 13, 2005, 3 replies, in forum: Performance Tuning for DBAs

Dear Guru, I've been new a new company for only a month and started analysing Index Fragmentation. After I ran DBCC DBREINDEX and capture data...