Viewing 15 posts - 451 through 465 (of 2,387 total)
I don't think indexes and fragmented DB files contributing to the slowness in this particular symptom.
If other applications also run in same server, The applications may compete system resources...
February 25, 2004 at 9:08 am
It removes the inactive part of the log without making a backup copy of it and truncates the log. NO_LOG and TRUNCATE_ONLY are synonyms.
DBCC SQLERF(LOGSPACE) tells the log...
February 24, 2004 at 12:12 pm
Your TEMPDB has been growed and only very little is being used. You can just shrink the MDF file to reduce the spaces it allocated.
February 24, 2004 at 12:07 pm
From BOL.
"When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical memory available. SQL Server grows or shrinks the buffer cache...
February 24, 2004 at 12:02 pm
Can you check the overall system performance with performance monitor, such as CPUs, memory, disk I/O and network?
Is this server a dedicated database server or shareed with applications?
February 24, 2004 at 11:39 am
"I have a server with 2 1Ghz processors and 4GB memory, running 2 instances of SQL2K SP3 under Win2K SP4. "
He has two instances running.
February 24, 2004 at 9:15 am
I will simply reindex all tables for this small database.
If you want to find out how fragmentation the data and indexes of the specified table, check dbcc showconfig.
February 23, 2004 at 1:00 pm
You have to make sure the sum of the max server memory values for all the instances is less than the amount of physical memory in the computer.
Each instance...
February 23, 2004 at 11:49 am
I would let system to balance the memory usage between OS and SQL Server instances by configuring SQL Server memory allocation dynamically.
Run performance monitor to monitor counter Memory: Available Bytes...
February 23, 2004 at 11:42 am
The maintenance plan runs sqlmaint.exe which could hung in your system. We have seen similar issues before.
February 23, 2004 at 9:05 am
Check sp_help_job and sp_help_jobhistory.
February 19, 2004 at 2:28 pm
From BOL.
"Transaction Log Architecture
Every Microsoft® SQL Server™ 2000 database has a transaction log that records all transactions and the database modifications made by each transaction. This record of transactions and...
February 19, 2004 at 2:21 pm
"Currently, I only have on user, when I am logged into the control panel or enterprise manager, and someone hits the site, they get an error saying couldn't log in."
What...
February 19, 2004 at 2:04 pm
Viewing 15 posts - 451 through 465 (of 2,387 total)