Viewing 15 posts - 181 through 195 (of 1,518 total)
Lynn Pettis (9/22/2011)
Are you using native SQL Server backups or are you running a third party backup application (LiteSpeed, et. al.)?
I'm using native backups.
__________________________________________________________________________________
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:21 pm
george sibbald (9/22/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 22, 2011 at 2:20 pm
I'm not sure to what extent this will suit your needs, but here is a script that loops through a list of servers stored in a db table and executes...
__________________________________________________________________________________
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 12:46 pm
j_bolduc (9/22/2011)
I have the exact same problem, if you found something to resolve it please let me know !Thanks !
Sorry, I don't have much new to report on this issue.
I...
__________________________________________________________________________________
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 9:29 am
A common cause that I have seen mentioned is bookmark lookups.
Process A is reading data from a non-clustered index, but needs to get to the base table to get the...
__________________________________________________________________________________
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 21, 2011 at 2:50 pm
Glad it worked! I have been burned by this before... 😉
__________________________________________________________________________________
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 21, 2011 at 2:14 pm
One more thing: get rid of the dashes in the "Data Source" name.
This might very well be the issue.
I have had this issue with the "-" characters before.
Best not...
__________________________________________________________________________________
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 21, 2011 at 1:24 pm
Try this:
Data Source=AGO-XXX-XX-001;User ID=XX;Password=bmcsdeSA1;Initial Catalog=XXX;Provider=SQLNCLI10.1;Persist Security Info=True;
(ie. no space before "Password").
__________________________________________________________________________________
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 21, 2011 at 1:19 pm
SJanki (9/21/2011)
Marios Philippopoulos (9/21/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 21, 2011 at 12:27 pm
Do any of your data sources in the job (DataSources tab) use sql auth to connect to the instance? If yes, you will need to manually re-enter the passwords in...
__________________________________________________________________________________
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 21, 2011 at 11:12 am
uncle_boris (9/20/2011)
SELECT * FROM sys.dm_io_virtual_file_stats(DB_ID(N'tempdb'),null);
The output shows it has had activity on both tempdb datafiles (ID 1 & 3)
Do you 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]
September 20, 2011 at 4:02 pm
uncle_boris (9/20/2011)
and this round robin pattern is for both TempDB data files and also the log files (if their were multiple log files of course).
I don't think it applies to...
__________________________________________________________________________________
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 20, 2011 at 3:16 pm
uncle_boris (9/20/2011)
I have my doubts as to...
__________________________________________________________________________________
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 20, 2011 at 3:10 pm
deleted
__________________________________________________________________________________
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 20, 2011 at 3:08 pm
My 2 cents, based on how we do it in our shop.
We used to create one tempdb data file per cpu core, but later on I realized too many data...
__________________________________________________________________________________
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 20, 2011 at 2:36 pm
Viewing 15 posts - 181 through 195 (of 1,518 total)