Activity overview
Latest activity by Keith_Walton
I got it to work. I had to join in sys.indexes to get index name: SELECT name FROM master..sysdatabases WHERE dbid = 8
USE support
GO
SELECT
object_name(partitions.object_id) AS [Table],
indexes.name AS [Index]
FROM
sys.partitions AS partitions
INNER JOIN
sys.indexes AS indexes
ON partitions.object_id = indexes.object_id
WHERE
hobt_id = 72057618332712960
It would be cool if SQL Monitor would do this automatically.
Thanks / comments
I got it to work. I had to join in sys.indexes to get index name:SELECT name FROM master..sysdatabases WHERE dbid = 8
USE support
GO
SELECT
object_name(partitions.object_id) AS [Ta...
How do I get a blocked index name for a deadlock?
Example:
Object blocked: Index/(Key) 72057618332712960
Process detail:
dbid: 8, object id: 72057618332712960, index id: (010086470766)
Both of these numbers are too long to be the object_id (INT) i...
Is there a debug mode or something that will create a log file? My boss is going to make me split the procs again... this is getting out of hand. / comments
Is there a debug mode or something that will create a log file? My boss is going to make me split the procs again... this is getting out of hand.
Nothing is highlighted as different between the two procs. / comments
Nothing is highlighted as different between the two procs.
> Does this mean that the large sp's still state that they're different after synchronization?
Yes.
> What differences are being reported when the sp's get over 32K?
I think it just highlights the last line procedure, but there is no visible difference. I'll check with my boss who does the synch. / comments
> Does this mean that the large sp's still state that they're different after synchronization?
Yes.
> What differences are being reported when the sp's get over 32K?
I think it just highlights the ...
Stored procedures over 32K always show as changed
Whenever one of my procedures gets really large and exceeds 32K, it always shows up as being different when I try to synchronize it between databases. In the past, I worked around this by splitting...
Does SQL Backup use tempdb?
I'm splitting my backup into two files for performance - each file goes to a different raid 0 drive array. I then copy these files onto my report server and restore them using two different drives....
Split backup - one thread for each file?
Right now I'm using THREADCOUNT = 2 to speed up my backup and restore. If I split the backup into two files instead of using THREADCOUNT (these options are mutually exclusive), will it automaticall...
I'm still having the problem, and your post is pretty old. / comments
I'm still having the problem, and your post is pretty old.
I recently increased my compression level to 3 - so I will change it back to 2. This problem only occurred once. I have my job set to auto-retry and it worked the 2nd time. I'm running version 5.2.0.2825 and I'm using 7 threads for this backup. I notice the original poster is using 6 - maybe the number of threads used can increase the likelihood of this error occurring. The database is 241 GB and I'm running on a 64-bit server. I am running multiple backups simultaneously.
I hope this information can help you reproduce the bug. / comments
I recently increased my compression level to 3 - so I will change it back to 2. This problem only occurred once. I have my job set to auto-retry and it worked the 2nd time. I'm running version 5.2....