Viewing 15 posts - 421 through 435 (of 496 total)
Found another one:
DB: 17 [BULK-OP-LOG]
Happens quite often. Is it critical?
July 31, 2003 at 5:23 am
Just found how to symplify this:
I will create a single table, named all_dbs_sysobjects with dbname column and all other columns that are present in sysobjects table, copy all database objects...
July 30, 2003 at 8:16 am
Fields who_waitresource and block_waitresource are both nchar(256):
[who_waitresource] [nchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[block_waitresource] [nchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
The data look like:
TAB: 11:1687077892 [[COMPILE]]
TAB: 11:1364668405 []
KEY: 12:651253475:1 (0e00bcea919b)
PAG: 7:1:39846
11:1:935464
sysobjects.id is...
July 30, 2003 at 6:53 am
quote:
64247 is the page number that is locked in some way.
Is it possible somehow,...
July 29, 2003 at 5:23 am
Like this:
insert #t exec('dbcc inputbuffer(' + '@who_spid' + ')')
?
July 24, 2003 at 8:02 am
No "GO" statement... Also, if I remove this code:
---------------------------------------------
insert #t exec('dbcc inputbuffer(@who_spid)')
SELECT top 1 @who_EventType = EventType
FROM #t
SELECT top 1 @who_Parameters = Parameters
FROM #t
SELECT top 1 @who_EventInfo = EventInfo
FROM #t
delete...
July 24, 2003 at 7:55 am
" I would recommend using only TCP/IP if at all possible."
- Not possible at this time, too many apps to rewrite or change.
July 23, 2003 at 9:59 am
Another reason not to trust it, is that this trace shows that most CPU was eaten by replications, but I did not change any replications before this and replications...
July 23, 2003 at 9:34 am
I did run Profiler for 2 hours, when high CPU usage was seen.
I am not sure if this gives the complete picture, since I used only these events for my...
July 23, 2003 at 9:29 am
"Do you have any performance log for last 10 minutes?"
- Like counter logs, in Performance snap in? I wonder how can this help...
This time I just seen it in...
July 23, 2003 at 7:14 am
What about setting Category field for this database to 0 in master..sysdatabases table?
This will fool the server, so it will think, that database is not for replication.
/* did this, when...
July 23, 2003 at 7:07 am
2Allen_Cui:
"The problem comes from last restore log statement. You have to add "FILE = file_number"... "
- This worked, but raised a few other questions:
since all log backups...
July 22, 2003 at 2:12 am
Just created a table to hold the locks snapshots, used:
EXEC sp_tableoption 'BLOCKS_HISTORY', 'text in row', 'on',
to be able to insert text data into this table, but got an error for...
July 18, 2003 at 7:45 am
Viewing 15 posts - 421 through 435 (of 496 total)