If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware’s I/O capacity meets the needs of a database application, if you need performance baselines, or if you want to identify any performance-related issues, then why not use the sqlio utility?
2014-02-13
6,077 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
In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able...
2013-04-22 (first published: 2013-04-10)
1,991 reads
Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.
2013-03-26
3,073 reads
2004-03-17
2 reads
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
Thanks for the reply. I guess what I was looking for was what dlls would get impacted without a reboot. And since it is production, to be on the safe side the safest thing is to reboot.
2004-02-12
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-02
2004-01-23
Another use is for searching the contents of MS Office documents (and pdf with free plugin) that are stored in the database.
2003-11-13
1 reads
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
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