Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. Today, Joe Deebeeay had a problem, no one else could help, so he found these exiled experts. Together Joe and the DBA-Team get to the bottom of high disk I/O.
2014-02-10
2,564 reads
The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It is generally used before installing SQL Server in order to ensure that new hardware can handle your expected loads. Bob Sheldon explains what it is and how to use it.
2014-01-24
3,493 reads
This article describes the warning "SQL Server has encountered n occurrence(s) of I/O requests taking longer than 15 seconds to complete on file <filename> in database <dbname>".
2009-09-01
4,018 reads
In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.
2009-06-23
8,504 reads
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and Assembler. I also spent quite a bit of time in Visual Basic. I loved it for prototyping and what we now call RAD development efforts.
2009-06-08
3,393 reads
Question 1)When you state job you mean a Sql Agent Tasks correct? i.e. something created with t-sql sp_add_job. Not that I'm aware of. Check out Gert Drapers presentation to PNWSSQL from July 2003 in the presentation archives of http://groups.msn.com/pnwsql There's a good PPT of how to trouble shoot sql 2k and sql 7.0 sql server agent […]
2004-03-17
The only problem we had was that our SCSI tape driver could not handle the /3GB switch, which meant that our backups failed until we could find the problem and replace the driver.Here is the code we used to enable AWE for SQL Server:sp_configure ' show advanced options', 1reconfiguregosp_configure 'awe enabled', 1reconfiguregosp_configure 'max server memory', […]
2004-03-15
Or use DBCC PINTABLE <t> SELECT * into #t FROM <t> DROP TABLE #t at startup to load and keep the table in the buffer cache.
2003-06-25
1 reads
Hey, Tom, we had a good discussion about this back in November. Here's the thread on it; you might find some good opinions... http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8029&FORUM_ID=49&CAT_ID=1&Topic_Title=One+or+More+than+One+Database%3F&Forum_Title=Strategies
2003-06-18
2003-06-13
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers