Activity overview
Latest activity by stevenhoban
missing column statistics
One of our servers seems to be burning extra cpu and when I have examined the default trace in profiler i see the following info:
NO STATS:([tempdb].[dbo].[##redgate_sqlmonitor_querywaitstats_serve...
sorry - ive got it ! / comments
sorry - ive got it !
Hi - My apologies also as i think i mentioned the no activity bit on another post !!!!
I have ran the query on the server but i cant find the location. It is on Windows Sever 2008.
c:\program files\red gate\sql backup 7\localIn the local i can see SQBCoreService - application, sqlbackupC - application, unins000.dat, unins000 -application and zlib1.dll
There is also a x64 folder with xp_sqlbackupdll
but no text file ! / comments
Hi - My apologies also as i think i mentioned the no activity bit on another post !!!!
I have ran the query on the server but i cant find the location. It is on Windows Sever 2008.
c:\program files...
I will try that however that doesnt really explain why this is happening.
We have always used level 4 with no issues.
As i mentioned the cpu pressure is high even when no backups are occuring on the system at the end of business hours. When nobody is using the server at night the cpu is at around 50% and that 50% is being used by the process sqbcoreservice. So how would compression levels effect an idle server ? / comments
I will try that however that doesnt really explain why this is happening.
We have always used level 4 with no issues.
As i mentioned the cpu pressure is high even when no backups are occuring on th...
Hi Peter.
We have 2 different databases on the server(s) that had the problem,both getting transaction log backups every 10mins. Looking at the graph in sql backup they seem to occur at the same time.
I have grabbed the sql the sql backup tool generates for the job and added it to the end of this reply.
In answer to your last question:
'Is there a specific interval where the backups cause the CPU utilization to max out, or does it happen with every transaction log backup?'
No there is no specific interval where the backups cause a problem - its very random as to when the issue occurs on different servers. As I mentioned - all servers have 2 databases which have tranaction log backups every 10 mins.
sql text
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP LOGS [dataA,dataB] TO DISK = ''S:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 1, ERASEFILES_REMOTE = 3, FILEOPTIONS = 4, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, COPYTO = ''\\Server1\TransactionLogBackups\Server11\'', INIT, THREADCOUNT = 2, VERIFY"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END / comments
Hi Peter.
We have 2 different databases on the server(s) that had the problem,both getting transaction log backups every 10mins. Looking at the graph in sql backup they seem to occur at the same ti...
SQBCoreservice consuming 80 - 90% cpu
Hello - i did post this ealier but i think it went into the wrong section of the web site so apologies if your re-reading this/.
We use backup 7 to do nightly backups (1am) and we backup the transa...
SQBCoreservice consuming 80 - 90% cpu
I need help troublshooting as to why whenever we get a 100% processor utilization using sql monitor the culprit is always SQBCoreservice consuming 80% - 90% processor usage.
There are no conflictin...
We have transaction log backups every 10 minutes but the full backups are done during the night.
The transaction log backups run througout the day with no issues. How come the cpu would be so high for this service ? / comments
We have transaction log backups every 10 minutes but the full backups are done during the night.
The transaction log backups run througout the day with no issues. How come the cpu would be so high ...
ah ok.
I can see SQBCoreService @ 44.9%
and
sqlservr @ 44.0%
I understand that the sqbcoreservice is not meant to cpu intensive ? Is this correct ?
Any pointers on where i go from here ? / comments
ah ok.
I can see SQBCoreService @ 44.9%
and
sqlservr @ 44.0%
I understand that the sqbcoreservice is not meant to cpu intensive ? Is this correct ?
Any pointers on where i go from here ?
How do i check that ? / comments
How do i check that ?