March 27, 2013 at 7:38 am
I need to create a query that will execute for 20 minutes or more so that connectivity and redundancy can be tested on the SAN. Any suggestions will be greatly appreciated. SQL 2008 R2 developer.
Thanks in advance.
March 27, 2013 at 9:43 am
TheGlossBoss (3/27/2013)
I need to create a query that will execute for 20 minutes or more so that connectivity and redundancy can be tested on the SAN. Any suggestions will be greatly appreciated. SQL 2008 R2 developer.Thanks in advance.
Maybe WaitFor?
http://msdn.microsoft.com/en-gb/library/ms187331(v=sql.105).aspx
March 27, 2013 at 11:44 am
you could populate a 50 column table with 100,000 rows all with GUIDS, then Cross join to itself and if that doesn't work add an Order by, for a good 20 minutes depending on your server.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
March 28, 2013 at 3:24 am
Make certain that you have completely flooded out the SAN cache which can be 10GBs in size.
A very simple way is to create a database with 100GB log. It needs to be zeroed out so any issues with the SAN will mean that the database wont start. Very crude.
March 31, 2013 at 6:58 am
Do you have a script available that creates the table and populates it with data? Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply