Viewing 15 posts - 106 through 120 (of 2,386 total)
creaet a SP to use xp_readerrorlog to load the errorlog file into a table, filter it and export it.
April 28, 2005 at 12:51 pm
Can you post your hardware information and SQL Server configuration information on both dev and prod servers?
Since you have already know which quesies do the loading, Can you compare the...
April 28, 2005 at 12:48 pm
Search Google for the command.
April 28, 2005 at 12:40 pm
Once the log either be backed up (Full Recovery Mode) or truncated (Simple Recovery Mode), Only the active transactions and committed transactions since last log backup or checkpoint are in...
April 28, 2005 at 12:38 pm
PAGEIOLATCH is used for disk-to-memory transfers and a significant waittime for these waittype suggests disk I/O subsystem issues.
April 28, 2005 at 11:46 am
Assuming your database is in full recovery mode.
You have to perform batch deletion to prevent log being filled up.
declare @go_on int
set @go_on = 1
while @go_on = 1...
April 28, 2005 at 9:27 am
1. Try to start SQL Server from command prompt like sqlservr.exe -E -m in single use mode.
2. Login to SQL Server with Query Analyzer.
3. Run follow command.
sp_configure 'allow update',...
April 28, 2005 at 8:44 am
You can't carry out same execution plan in different way as it is controlled by optimizer. But what you can do is to force optimizer to generate different execution plan and...
April 28, 2005 at 8:00 am
What internal switch are you referring to? Can you post the T-SQL statement and execution plan?
April 28, 2005 at 7:13 am
Page split could be normal in your situation depending on how busy your system is.
I would suggest you to run DBCC SHOWCONTIG to tables to find out fragmentation information for...
April 27, 2005 at 6:57 pm
If you want to know which applications are consuming the processor time, You can use Task Manager or Performance monitor monitor it.
If you are sure the high CPU usage is...
April 27, 2005 at 2:34 pm
You may have to run Profiler to trace it.
Or
Create a delete trigger on sysobjects and a delete trigger on that table to notify you when someone tries to delete the...
April 27, 2005 at 2:32 pm
In this case, you have to wait until it completes, Cancelling the process colud trigger the rollback which may take even longer time.
I wouldn't run dbcc check with repair option, instead,...
April 27, 2005 at 11:29 am
Your dbcc sounds like to be blocked. Run sp_who2 active to confirm it.
April 27, 2005 at 10:19 am
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=177917
It sound like blocking too.
Using hints will force SQL Server to run in different execution plan.
April 27, 2005 at 8:33 am
Viewing 15 posts - 106 through 120 (of 2,386 total)