Viewing 15 posts - 1,021 through 1,035 (of 1,518 total)
Marios Philippopoulos (7/31/2008)
Carl Federl (7/31/2008)
Have you optimized tempdb? See "Concurrency enhancements for the tempdb database" at...
__________________________________________________________________________________
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]
July 31, 2008 at 6:08 pm
Carl Federl (7/31/2008)
"But I forget what the 3rd number means. Any ideas? " The Page number.Have you optimized tempdb? See "Concurrency enhancements for the tempdb database" at http://support.microsoft.com/kb/328551
Thanks 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]
July 31, 2008 at 5:49 pm
Thanks for the suggestion. It looks like the contention involves the sysobjects table on both the user and tempdb databases.
Moving the temp table creation and deletion statements outside the transaction...
__________________________________________________________________________________
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]
July 31, 2008 at 3:58 pm
In sysprocesses table for my SPID I see PAGELATCH_SH as the lastwaittype.
__________________________________________________________________________________
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]
July 31, 2008 at 2:52 pm
Marios Philippopoulos (7/31/2008)
rbarryyoung (7/31/2008)
__________________________________________________________________________________
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]
July 31, 2008 at 2:34 pm
rbarryyoung (7/31/2008)
Actually, I can not see why you even need a transaction for this. If everything is in TempDB anyway, why do you need Transactions, Commit or Rollback?
Good point.
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]
July 31, 2008 at 1:13 pm
Carl Federl (7/31/2008)
spid dbid ObjId IndId Type Resource Mode ...
__________________________________________________________________________________
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]
July 31, 2008 at 12:45 pm
Both the data and log files of tempdb are on the same drive location.
Could this be caused by a slow drive?
__________________________________________________________________________________
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]
July 31, 2008 at 11:12 am
Thanks guys, I found a link here on SSC specifically for this, which pretty much does what you are referring to:
http://www.sqlservercentral.com/articles/SSIS/61987/
__________________________________________________________________________________
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]
July 30, 2008 at 5:45 pm
GSquared (7/30/2008)
SSIS is great for that. For scheduled data transfers between servers, SSIS would be very high on my list of potential tools.
So I'm not crazy after all. 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]
July 30, 2008 at 1:22 pm
Jason Crider (7/30/2008)
Try this
thanks, I will go through these steps.
__________________________________________________________________________________
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]
July 30, 2008 at 11:51 am
colin Leversuch-Roberts (7/30/2008)
Mind it depends upon database size and so on...
__________________________________________________________________________________
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]
July 30, 2008 at 11:48 am
GSquared (7/30/2008)
__________________________________________________________________________________
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]
July 30, 2008 at 11:43 am
Ken Shapley (7/17/2006)
"Generally, the rule of thumb is to have as much as RAM as your data file is."
Did you come up with this rule yourself? How many databases...
__________________________________________________________________________________
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]
July 30, 2008 at 7:26 am
Does the "Process\Working Set" counter include AWE memory utilization?
I don't think it does.
In my machine it reaches 700,000,000 (700 MB), which is way below the 13.2 GB allocated using...
__________________________________________________________________________________
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]
July 30, 2008 at 7:23 am
Viewing 15 posts - 1,021 through 1,035 (of 1,518 total)