Comments
Sort by recent activity
Cluster's data.sdf is an enormous 148KB ( [image] ) / comments
Cluster's data.sdf is an enormous 148KB ( )
It also turns out that the server has Activity dating back to 9 Oct 2012. The sqbdata process is responsible for the long running query, hence the 6 full months of activity may be the underlying issue, not the client or server dat or sdf files...
Maintenance plan for History Cleanup is now configured, executed, and we're down to 30-days. / comments
It also turns out that the server has Activity dating back to 9 Oct 2012. The sqbdata process is responsible for the long running query, hence the 6 full months of activity may be the underlying i...
After TWO HOURS the cluster's Activity History is finally back!
It also incurred a SQL "Long Running Query" Alert from SQL Monitor - the query ran for 8718.0400001 seconds!!! / comments
After TWO HOURS the cluster's Activity History is finally back!
It also incurred a SQL "Long Running Query" Alert from SQL Monitor - the query ran for 8718.0400001 seconds!!!
UPDATE:
I didn't delete the data.sdf files on the stand-alone Dev and QA Servers and the Activity History just came up fine, immediately after adding the servers to the new laptop.
Only the CLUSTER Activity History is now a problem. / comments
UPDATE:
I didn't delete the data.sdf files on the stand-alone Dev and QA Servers and the Activity History just came up fine, immediately after adding the servers to the new laptop.
Only the CLUSTER...
Hi James,
I was waiting for advice on the data.sdf file on the SQL Cluster due to the configuration of the SQL Backup Service with respect to the cluster manager.
Apologies for misleading you all, I didn't delete THAT file, just the client files. / comments
Hi James,
I was waiting for advice on the data.sdf file on the SQL Cluster due to the configuration of the SQL Backup Service with respect to the cluster manager.
Apologies for misleading you all, ...
I deleted all the recommended files.
Activity History is at 10 minutes and counting...
I can see the Jobs, no problem.
Next steps, please, as this version is definitely broken... / comments
I deleted all the recommended files.
Activity History is at 10 minutes and counting...
I can see the Jobs, no problem.
Next steps, please, as this version is definitely broken...
Thanks, James. Servers.dat is only 3KB, to complete the file size portfolio. / comments
Thanks, James. Servers.dat is only 3KB, to complete the file size portfolio.
One laptop I'm having issues with is a brand new Dell M6700 running Windows 8 Pro.
The 1.dat is only 12,669 KB.
I don't have a server.dat file.
I have a localDataCache.dat file of 31KB, though.
Do I delete the latter?
On the Server, the 1.dat is 25,548 KB, 2.dat is 30 KB and localDataCache.dat is 30 KB.
Please advise. / comments
One laptop I'm having issues with is a brand new Dell M6700 running Windows 8 Pro.
The 1.dat is only 12,669 KB.
I don't have a server.dat file.
I have a localDataCache.dat file of 31KB, though.
Do ...
I left it over 20 minutes before posting a bug report. When I returned to the server, a {sa} crash had been trapped and sent to Red Gate.
I don't care about the detailed stats as I'll have a fresh set after the cache is rebuilt and the daily Full backups have run. Thanks for the workaround.
MINOR POTENTIAL PROBLEM: one of the SQL Backup instances is on a cluster and the cluster manage is aware of the service - do NOT want to accidentally fail the beast over [image] Any advice?
Can we say NO to the Cache Compress? I have FIVE more machines to upgrade and don't want to have to fudge around on all ten machines, so far... / comments
I left it over 20 minutes before posting a bug report. When I returned to the server, a {sa} crash had been trapped and sent to Red Gate.
I don't care about the detailed stats as I'll have a fresh...
Don't have time for that. Will plod on with IE9 and await the next rev of SQL Monitor.
Use me as a Beta if you'd like... / comments
Don't have time for that. Will plod on with IE9 and await the next rev of SQL Monitor.
Use me as a Beta if you'd like...