Viewing 15 posts - 346 through 360 (of 1,518 total)
Based on the following link, there is no way to change the default-trace file size and number of log files; is that correct?
http://www.eggheadcafe.com/software/aspnet/32855710/default-trace-logs--increase-size.aspx
__________________________________________________________________________________
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]
February 23, 2011 at 2:26 pm
drawlings (2/22/2011)
Default trace.Dan
Thanks, it turns out default trace is being used behind the scenes for the SSMS report.
I have the following query from the profiler trace:
select ObjectName
, ...
__________________________________________________________________________________
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]
February 23, 2011 at 1:54 pm
Jeffrey Williams-493691 (2/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]
February 23, 2011 at 10:46 am
SQLkiwi (2/23/2011)
Craig Farrell (2/23/2011)
I'm going to need to read that...
__________________________________________________________________________________
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]
February 23, 2011 at 9:38 am
Here is a good link and a query from that link I have found very useful:
--Assessing transaction log impact
--http://www.simple-talk.com/sql/database-administration/investigating-transactions-using-dynamic-management-objects/
SELECT
DTST.[session_id],
DES.[login_name] AS [Login Name],
DES.[program_name] AS [Program Name],
DB_NAME (DTDT.database_id) AS...
__________________________________________________________________________________
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]
February 22, 2011 at 3:53 pm
The degree of parallelism setting applies to individual operators in a query plan, eg. a hash-match operator could itself be spreading its work over several processors. Since a query plan...
__________________________________________________________________________________
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]
February 22, 2011 at 3:49 pm
Shawn Melton (2/22/2011)
By the way, thanks for the links, Marios.
No problem, BTW a quick thing to do to find out what may be using sp_configure is to script out all...
__________________________________________________________________________________
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]
February 22, 2011 at 1:07 pm
gemisigo (2/22/2011)
Two more questions though....
__________________________________________________________________________________
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]
February 22, 2011 at 12:11 pm
I saw this link that describes a very similar issue, this time with the IF EXISTS clause.
Are we looking at some bizarre behavior from the query engine here?
http://www.sqlservercentral.com/Forums/Topic957634-338-1.aspx
__________________________________________________________________________________
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]
February 9, 2011 at 11:00 am
AlexSQLForums (2/9/2011)
WHILE EXISTS
(
SELECT top 1 NULL
FROM dbo.tmp1 TMP (NOLOCK)
...
__________________________________________________________________________________
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]
February 9, 2011 at 10:59 am
davidc-702140 (2/4/2011)
Try looking at this to watch your memory problem:select * from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR'
When I run this on my server I get that virtual_memory_reserved_kb = 6,322,496, or...
__________________________________________________________________________________
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]
February 4, 2011 at 9:53 am
Thank you, I will look at these.
__________________________________________________________________________________
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]
February 4, 2011 at 9:12 am
BTW, I have some scripts I use to automate SSAS-db restores from production to the D/R server as a nightly job. I use powershell with SQL Server 2008 AMO. See...
__________________________________________________________________________________
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]
January 28, 2011 at 2:58 pm
Vivien Xing (1/28/2011)
Marios Philippopoulos (1/27/2011)
Vivien Xing (5/7/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]
January 28, 2011 at 1:42 pm
Vivien Xing (5/7/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]
January 27, 2011 at 11:54 am
Viewing 15 posts - 346 through 360 (of 1,518 total)