Showing posts with label images. Show all posts
Showing posts with label images. Show all posts

Monday, March 26, 2012

Info on Load Testing Tools Needed

Hello, we are a MS SQL 2000 shop and use a web server running IIS to serve up
document images to Internet users (about 1,500 a day). Can someone recommend
me some quality simulator tools that we can use to simulate 1500 users
hitting our website daily, and 4500 query requests to our SQL Server daily?
Thanks in advance for any info.
Here is a huge list:
http://www.softwareqatest.com/qatweb1.html
You could also use, MS ACT:
http://msdn.microsoft.com/library/de...actml_main.asp
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:4CFE0B70-51C4-4A88-9AF9-A8CE0D09D02F@.microsoft.com...
> Hello, we are a MS SQL 2000 shop and use a web server running IIS to serve up
> document images to Internet users (about 1,500 a day). Can someone recommend
> me some quality simulator tools that we can use to simulate 1500 users
> hitting our website daily, and 4500 query requests to our SQL Server daily?
> Thanks in advance for any info.
|||Thanks--looks like good stuff!
"oj" wrote:

> Here is a huge list:
> http://www.softwareqatest.com/qatweb1.html
> You could also use, MS ACT:
> http://msdn.microsoft.com/library/de...actml_main.asp
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:4CFE0B70-51C4-4A88-9AF9-A8CE0D09D02F@.microsoft.com...
>
>

Info on Load Testing Tools Needed

Hello, we are a MS SQL 2000 shop and use a web server running IIS to serve up
document images to Internet users (about 1,500 a day). Can someone recommend
me some quality simulator tools that we can use to simulate 1500 users
hitting our website daily, and 4500 query requests to our SQL Server daily?
Thanks in advance for any info.Here is a huge list:
http://www.softwareqatest.com/qatweb1.html
You could also use, MS ACT:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/act/htm/actml_main.asp
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:4CFE0B70-51C4-4A88-9AF9-A8CE0D09D02F@.microsoft.com...
> Hello, we are a MS SQL 2000 shop and use a web server running IIS to serve up
> document images to Internet users (about 1,500 a day). Can someone recommend
> me some quality simulator tools that we can use to simulate 1500 users
> hitting our website daily, and 4500 query requests to our SQL Server daily?
> Thanks in advance for any info.

Monday, March 19, 2012

Indexing PDFs in SQL Server 2005

Did you run the pdf's through filtdump to see if there is any textual info
in them? Sometimes pdf's are images only.
Can you send me some of these pdf's offline or post them here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ddaiker" <ddaiker@.gmail.com> wrote in message
news:1167410997.650379.296710@.i12g2000cwa.googlegr oups.com...
> I'm having troubles getting SQL Server 2005 FTS to index PDFs stored in
> and image field with a doctype field value of "PDF". The file is being
> processed as I can query on the filename but I get no hits when
> querying any of the content. FiltDump returns all the plain text of
> the document.
> I've installed Acrobat Reader 7 so the IFiler being used is "C:\Program
> Files\Adobe\Acrobat 7.0\Reader\AcroRdIF.dll"
> I did some Googling and found some references to allowing SQL Server to
> use system filters and unsigned filters so I ran these two commands on
> my database, restarted the services and reindexed but still no luck.
> exec sp_fulltext_service 'load_os_resources',1
> exec sp_fulltext_service 'verify_signature', 0
> Anybody have any ideas what I'm doing wrong?
>
Hilary, thanks agian for your help with my FTS problems.
I've tried several PDFs, FiltDump spits out the expected text for all
of them. I'm emailing you one of the PDFs that I created as a test
using MS Word 2003 and the CutePDF printer driver.
Hilary Cotter wrote:[vbcol=seagreen]
> Did you run the pdf's through filtdump to see if there is any textual info
> in them? Sometimes pdf's are images only.
> Can you send me some of these pdf's offline or post them here?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ddaiker" <ddaiker@.gmail.com> wrote in message
> news:1167410997.650379.296710@.i12g2000cwa.googlegr oups.com...
|||Well, after redoing the following steps it's now indexing my PDFs (and
the PDF properties too!).
1) Run "exec sp_fulltext_service 'load_os_resources',1"
2) Run "exec sp_fulltext_service 'verify_signature', 0"
3) Restart SQL Server
4) Delete all the rows in my table with PDFs in them and re-insert
them.
I know I did all these last week but this time it worked? Now I'll
experment with needing both these settings and what Acrobat 8.0 does to
the equasion.
Hilary Cotter wrote:[vbcol=seagreen]
> Did you run the pdf's through filtdump to see if there is any textual info
> in them? Sometimes pdf's are images only.
> Can you send me some of these pdf's offline or post them here?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ddaiker" <ddaiker@.gmail.com> wrote in message
> news:1167410997.650379.296710@.i12g2000cwa.googlegr oups.com...