Viewing 15 posts - 166 through 180 (of 1,518 total)
Lynn Pettis (10/16/2011)
Can you give us the actual error message(s) you are getting?
Mentioned in my initial posting:
"ErrorNumber - 3013 : ErrorMessage - BACKUP DATABASE is terminating abnormally."
I capture this error...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2011 at 9:55 am
SpringTownDBA (10/14/2011)
google says http://support.microsoft.com/kb/290787
Thanks, but this link does not apply to sql 2008 (whick I'm on). Besides, the exact same backup command works fine on its own (outside the internal-activation...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 15, 2011 at 5:09 am
Microsoft have kindly provided me with the following query for obtaining those reports with the largest size contribution to ReportServerTempDB:
--Reports that are largest contributors to ReportServerTempDB size through tables Segment,...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 12, 2011 at 9:14 am
Thanks, good to know.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 12, 2011 at 8:10 am
Michael Valentine Jones (10/5/2011)
http://technet.microsoft.com/en-us/library/ms156016.aspx
"...
Report Server Temporary Database
Each report server database uses a related temporary database to store session...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 5, 2011 at 2:29 pm
Thanks for responding.
I am also thinking of opening a case with Microsoft on this because it doesn't seem right.
There seems to be no pruning process on this table, shipping...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 5, 2011 at 2:08 pm
Here is my code for this (attached).
Run script "CurrentlyRunningJobs_GetTotalDurationCompletedSteps.sql.txt" in a DBA-owned database on the instance in question, say UTILDB, to create stored procedure [CurrentlyRunningJobs_GetTotalDurationCompletedSteps].
Then run script "CurrentlyRunningJobs.sql.txt" to get...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 4, 2011 at 2:03 pm
marat-oz (9/1/2011)
Hi,I developed the following SP to stop long running jobs and I am using it for a while with no issues:
...
Thanks for sharing; I tried it and, indeed, your...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 4, 2011 at 10:14 am
Kwisatz78 (10/4/2011)
My server is SQL 2005 x86 and AWE is not switched on, so I guess this is why its stuck at 200,000?
Correct.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 4, 2011 at 8:47 am
Ratheesh.K.Nair (9/28/2011)
There are 100 of process running in that server and how can i find those using tempdb??
Run this:
--http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx#EX1AE
SELECT
R1.session_id
, ...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 30, 2011 at 3:06 pm
There are cases where a blocking session may not fall under either of these criteria:
...
WHERE r.blocking_session_id <> 0
OR EXISTS
...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 30, 2011 at 2:14 pm
Kwisatz78 (9/30/2011)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 30, 2011 at 2:02 pm
Instead of killing the sessions one by one, try doing this:
ALTER DATABASE [dbname] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;
-- this will kill all connections to the db, except for...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 22, 2011 at 3:14 pm
george sibbald (9/22/2011) so I was right then!
Yes! 😉
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 22, 2011 at 3:01 pm
GilaMonster (9/22/2011)
Job history?
The history log of the failure is not very helpful:
Message
Executed as user: xxxx\xxxx. ..._Content', file 'xxxx' on file 1. [SQLSTATE 01000] (Message 4035) Processed 68 pages for...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 22, 2011 at 2:33 pm
Viewing 15 posts - 166 through 180 (of 1,518 total)