Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New San/Compellent testing Expand / Collapse
Author
Message
Posted Wednesday, March 27, 2013 7:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 11:28 AM
Points: 8, Visits: 287
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.
Post #1435905
Posted Wednesday, March 27, 2013 9:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
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
Post #1435997
Posted Wednesday, March 27, 2013 11:44 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 922, Visits: 2,524
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
Post #1436072
Posted Thursday, March 28, 2013 3:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 5:53 AM
Points: 51, Visits: 296
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.



Post #1436328
Posted Sunday, March 31, 2013 6:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 11:28 AM
Points: 8, Visits: 287
Do you have a script available that creates the table and populates it with data? Thanks
Post #1437288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse