There's no such thing has a block of TSQL that you can run that will adequately stress your server. Stressing is based on concurrency, not on complexity. If you don't want to use a tool, write your own in CF. Write a CFML page that executes something powerful and typical (like a three table join on something like the Northwind database) and put this in a multi-frame page, loading the page in each frame. Put some code in each page that keeps it refreshing. (Details on this sort of thing are in Chris Cortes's book, Optimizing ColdFusion) Watch your server's resource meter, and see what happens.
The resource kit specified is a very common one, and building a VB project is very simple (File->Make Project) I'm sure the list is full of developers who would be willing to build this app for you. --- Billy Cravens ----- Original Message ----- From: "Neil H." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 4:17 PM Subject: Re: Stressing SQL server > I was told to simply compile a program. How simple is it get a VB compiler > and then compile code? It would be easier for someone to suggest a piece of > transact SQL that would do the same. > > Neil > > ----- Original Message ----- > From: "BILLY CRAVENS" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, December 18, 2001 4:08 PM > Subject: Re: Stressing SQL server > > > > Actually, you were pointed to an excellent resource, but you disregarded > it > > and were practically antagonistic at the concept of using something you > were > > unfamiliar with. As such, can you expect much more than sarcasm? > > > > --- > > Billy Cravens > > > > ----- Original Message ----- > > From: "Neil H." <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, December 18, 2001 2:00 PM > > Subject: Re: Stressing SQL server > > > > > > > THAT is what I am missing. Shoot. You know where I can download a web > > > browser? > > > > > > Man nice guy, with lots of help. Thought I would go to my peers but > > instead > > > I get RTFM. > > > > > > Thanks a bunch! > > > > > > Neil > > > > > > ----- Original Message ----- > > > From: "BILLY CRAVENS" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Tuesday, December 18, 2001 2:50 PM > > > Subject: Re: Stressing SQL server > > > > > > > > > > A search on Google returned 905 results - a few of them actually > pointed > > > to > > > > some valid resources. I'd post some URL's, but I don't want to > presume > > > that > > > > you have a web browser installed. > > > > > > > > --- > > > > Billy Cravens > > > > > > > > ----- Original Message ----- > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Tuesday, December 18, 2001 11:37 AM > > > > Subject: Re: Stressing SQL server > > > > > > > > > > > > > Simply compile? I am a CF developer, no compiling. How in the > world > > > > would > > > > > you think I would have the tools to compile? > > > > > > > > > > Neil > > > > > > > > > > ----- Original Message ----- > > > > > From: "Ron Anderson" <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Tuesday, December 18, 2001 12:25 PM > > > > > Subject: RE: Stressing SQL server > > > > > > > > > > > > > > > > In the SQL 2K resource Kit, there's a "data hammer" component that > > can > > > > be > > > > > > used for load testing SQL. It's in VB, simply compile and run. > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Neil H. [mailto:[EMAIL PROTECTED]] > > > > > > Sent: Tuesday, December 18, 2001 8:27 AM > > > > > > To: CF-Talk > > > > > > Subject: Stressing SQL server > > > > > > > > > > > > > > > > > > Can anyone send me a block of code that I can use on a SQL 2000 > > server > > > > > that > > > > > > will push CPU and memory to the limit? > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
