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

Loading server with concurrent user Expand / Collapse
Author
Message
Posted Tuesday, June 29, 2010 3:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 3:34 AM
Points: 378, Visits: 886
Hi
I was thinking to put some load on our dev server from different sessions(say 99 sessions). So if I have say thre big tables TAB1,Tab2,TAb3, then I want 33 sessions for each of these queries:
select * from tab1(fired by 33 sessions)
select * from tab2(fired by 33 sessions)
select * from tab3(fired by 33 sessions)

what can be possible solutions?
I tried by creating 99 batch files,putting select statement in them and running them together but this doesn't look optimal solution as it opens lot of batch file windows.
Can I do it from single batch file or thru some TSQL command which may open different sessions for me??
Thanks in advance...


-----Table Proc Index Performance TSQL &&%$#@*(#@$%.......------------
Deep Into SQL Jungle
Post #944515
Posted Monday, July 5, 2010 12:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
Not enough details provided by you, I am getting what you are looking for?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #947389
Posted Monday, July 5, 2010 2:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 3:34 AM
Points: 378, Visits: 886
Basically what I am trying to get is open 99 sessions of SQL server and run some queries in each session.
But I dont want to open 99 connections manually.I am looking for some TSQL script or batch file which can do it.
I gave example queries in my original post.


-----Table Proc Index Performance TSQL &&%$#@*(#@$%.......------------
Deep Into SQL Jungle
Post #947414
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse