CPU Usage is easy :) You will have to restart your server to stop this though...
DECLARE @Count int SET @Count = 0 SET @BigNumber = 0 WHILE @Count != 1 SET @Count = 0 As far as memory goes...perhaps you could open multiple large recordsets in enterprise manager? jon ----- Original Message ----- From: "Neil H." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 5: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 > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
