Viewing 15 posts - 361 through 375 (of 708 total)
Best case for physical disk drives: 100-150 IOPS per drive.
SSDs put up much bigger numbers; individual drives hitting 100,000 IOPS or better on the right benchmarketing loads.
What is more important...
May 18, 2011 at 1:04 pm
For disk transfer rates, look at the DMF sys.dm_io_virtual_file_stats. The values are cumulative, so you need to sample it over a time range a diff the values.
As for network transfer...
May 18, 2011 at 12:16 pm
SQL Server Mirroring on Window 2003 servers can see all sorts of networking problems if you have installed Windows Server 2003 SP2, which auitomatically turns on something called the...
May 17, 2011 at 1:28 pm
Are you running the RTM version of SSMS 2005? That was the case with the original version, to present 'look, we're more secure this way', but after everyone howled about...
May 16, 2011 at 4:48 pm
What's also important is to not look at this DMF for the whole time the server has been up - idle periods flatten the spikes out. For this data to...
May 16, 2011 at 3:37 pm
I ignore io_stall and only look at the different read and write stalls. The io_stall number is rather out of whack with those two, and gives me no useful data....
May 16, 2011 at 3:31 pm
There is a way of scripting out all of the statistics. I haven't used the scripts to build a database for testing, only for sending the results to Microsoft Support...
May 16, 2011 at 6:31 am
The memory dump is simply the internal binary representation of the row - the raw data as it is stored on the page. In the DBCC PAGE output in the...
May 16, 2011 at 5:22 am
MERGE can do that. I'd build you a statement but I'm a little lost on what you're asking.
Corresponding intTrialID by what? Do you mean delete all TableA.intTrialID = 1 rows...
May 16, 2011 at 5:10 am
TT-131210 (5/11/2011)
[...] Also, the stored procedure that I will be calling and passing the table variable is on a linked server. Will that be an issue?Tim
That will be...
May 11, 2011 at 5:00 pm
While I'm all for having new speakers the Summit isn't the place for real newbies. That's what all the Chapters (real & virtual), SQLSaturday's, SQLRally's, and various online sessions...
May 3, 2011 at 2:17 pm
Did anybody look at the pictures before responding?
Looks like you're rebuilding an index, or performing other index-modification work. You'll get lots of page latching on metadata pages (mostly the GAM)...
May 2, 2011 at 11:35 am
Since you're already passing in a string list of values, and adding them to a dynamic (string) command, why bother splitting them?
DECLARE @sql as varchar(5000) = '
SELECT E.LastName + '',...
April 14, 2011 at 4:05 pm
PolyServe has reached end-of-life. It beat our experiences with Windows 2003 clustering (such failovers not working or taking too long), but Windows 2008 clustering is an entirely different animal, and...
April 12, 2011 at 1:41 pm
We have many PolyServe Matrix clusters of up to four physical nodes, each having up to eight SQL Server 2005 Enterprise x64 instances with databases up to 20TB each.
We're phasing...
April 11, 2011 at 4:05 pm
Viewing 15 posts - 361 through 375 (of 708 total)