Hi,

The system has 4 CPUs and 4GB RAM Memory. Currently, the IIS Web server also is running on this box, but we're moving it to another server soon.
The database size about 10GB. The biggest table has 5 million rows, second biggest table has 2 million rows. The performance gets hurt and slow inconsistently. Sometimes, it gets really slow after few hours useage. Not necessary 'after the bulk load or bulk import'. I checked the shared memory pool, and it wasn't full at that time. The reboot/restart the instance doesn't solve the issue.