Viewing 15 posts - 1,486 through 1,500 (of 1,518 total)
Also:
Add a separate drive for index filegroups. I/O throughput can benefit when non-clustered index operations are separated from the rest.
In my workplace, we also keep separate drives for full and...
__________________________________________________________________________________
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 13, 2008 at 9:27 am
Create as many tempdb data files as there are processors. Create them equally sized so that they take up pretty much the entire tempdb drive - perhaps with a couple...
__________________________________________________________________________________
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 13, 2008 at 9:22 am
Greg Edwards (2/8/2008)
Can you setup Kerberos on the machines?
http://support.microsoft.com/?kbid=319723
We have IIS and RS on one machine, SQL and SSAS on another, and it...
__________________________________________________________________________________
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 8, 2008 at 7:50 am
I may not be able to check on this topic for the next 10 days or so due to something unexpected.
Pls post any feedback here, and I will get 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]
February 7, 2008 at 8:19 pm
Lester Policarpio (2/7/2008)
use tempdb dbcc showfilestats
-- For DB Size : (totalextents*64)/1024
-- FOr DB Used : (usedextents*64)/1024
-- For DB Free Space :
--((totalextents*64)/1024)-((usedextents*64)/1024)
FOr log...
__________________________________________________________________________________
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 7, 2008 at 6:51 pm
Steve Jones - Editor (2/7/2008)
One thing you could do is track the space in tempdb using a proc and either store it 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]
February 7, 2008 at 1:27 pm
After enabling remote errors, the error message changed to the following:
An error has occurred during report processing.
Cannot create a connection to data source 'Dynamic_Connection'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
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]
February 7, 2008 at 10:51 am
Rajan John (2/6/2008)
I have used two methods. one - call sp_spaceused or use the builtin "SpaceAvailableInMB" method in sql dmo "DBFile" object. Call the dmo script from a recurring schedule.
Thanks...
__________________________________________________________________________________
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 7, 2008 at 8:57 am
Can we set an alert once tempdb *allocated* space (not the actual size of the file, which in my case stays constant) reaches a certain threshold?
I don't think it's possible...
__________________________________________________________________________________
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 6, 2008 at 8:58 pm
Thanks Steve,
I'm interested in tracking size over time, specifically tempdb used space over time. I did not have alerts in mind, but that sounds like a good idea.
As I mentioned,...
__________________________________________________________________________________
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 6, 2008 at 8:54 pm
vidhya sagar (10/28/2007)
MS won't release SP5 for SQL2k since official support for SQL server 2000 will be ended by mid of 2008.
To clarify, MS will not be releasing any new...
__________________________________________________________________________________
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 5, 2008 at 9:51 am
Also, try installing under the local admin account (as opposed to a domain account). The local admin has superior privileges, which might help you get over the hump.
__________________________________________________________________________________
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 2, 2008 at 8:41 am
Make sure that the account you are using to do the installation is local admin on the server machine.
__________________________________________________________________________________
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 2, 2008 at 8:36 am
The latest post-SQL-2000-SP4 rollup, version 8.0.2187, has a lot of the fixes required, including a fix for the AWE bug.
Microsoft has extended support for SQL 2000 SP4 to 2013, although...
__________________________________________________________________________________
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 2, 2008 at 8:23 am
From "Use Missing-Index Groups for Query Tuning", SQL Server Mag., April 2007, by Kalen Delaney
"You can disable the missing-index feature by starting an instance of SQL Server using the -x...
__________________________________________________________________________________
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 30, 2008 at 5:18 pm
Viewing 15 posts - 1,486 through 1,500 (of 1,518 total)