Search Results | SQL Server Performance Forums

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

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

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

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...