Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts

Thursday, February 16, 2012

>> Can Google web search index the data in my database?

I have content about projects that I store in a MS SQL database.
People access this information through pages which are dynamically
created in PHP. Since my content is stored in the database, how can I
get google web search (at google.com) to included that content when it
indexes my site? Is it a possibility? Thank you so much!I don't think this is the right group for this question (but I'm not
sure which group is right). Here are some links that might help
(especially the first one):
https://www.google.com/webmasters/s...ocs/en/faq.html
http://desktop.google.com/developerguide.html
http://www.google.com/enterprise/mini/index.html

Razvan|||gene.ellis@.gmail.com wrote:
> Since my content is stored in the database, how can I
> get google web search (at google.com) to included that content when it
> indexes my site? Is it a possibility? Thank you so much!

Google will NOT index your database. However, Google will follow all
the links on your website. If your website is designed so that the
dynamic content is only accessible though, for example form fields,
then google will not be able to find it. On the other hand, any
dynamic content that is accessible through a simple hypertext link will
be found and indexed by google.

> I have content about projects that I store in a MS SQL database.

As an example, let's say that you have a page named projectinfo.php
that accepts as input a variable named ProjectID and looks up and
displays info about that project. On some other page, a user selects
the project that they want to view. The user is then directed to
projectinfo.php. If that other page consists of a form with a
drop-down box, so that the user selects a project from the drop down
and then hit's a submit button, then google probably will not be able
to follow it.

On the other hand, if that other page contains anchors with hrefs like:
projectinfo.php?projectID=1
projectinfo.php?projectID=2
projectinfo.php?projectID=3

Then google absolutely will be able to follow those links and index the
pages.

Hope that helps

Monday, February 13, 2012

%disk time > 2500

Is the %disk time > 2500 bad ? What does that mean ? My pages/sec seem to be
low ..around 0 with a few spikes here and there..so why is the %disk time
high ?
ThanksHi,
%disk time > 2500 , are you saying that your disk is running at 2500%, if
you are I want one of those disk :)
Can you tell me if you are using a software RAID 5 config? If so this might
explain the numbers. If you are using a software raid try dividing this
number by the number of disks. Although thinking a bit more I doubt
software RAID would explain the figure.
Basically PhysicalDisk:% Disktime shows how busy each disk is. long period
of busy times say over 50% for 10 minutes indicates problems (too many
writes/reads , slow disk) So a figure of 2500 is really saying something.
You should look to other counters like %disk read time %disk write time and
Avg Disk queue length to see where the issues are . If this activity is not
caused by paging then you have a very very busy machine.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
program
http://www.ag-software.com. Free programming tools
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O30Ol8LWDHA.392@.TK2MSFTNGP11.phx.gbl...
> Is the %disk time > 2500 bad ? What does that mean ? My pages/sec seem to
be
> low ..around 0 with a few spikes here and there..so why is the %disk time
> high ?
> Thanks
>

Thursday, February 9, 2012

## How to acquire the SQL Server 2000 Performance data? ##

I want to write a application monitering program to collect the SQL
Server 2000 performance data,
such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
, In Oracle , there are the v$ views and DBA view , which I can find
the information I interested, the question is , is there a similar suit
of view in SQL Server 2000 to provide the performance information ?
Thank you very much, I will be mad by this question, for I have googled
all the day , but in vain(wangzhi0417@.gmail.com) writes:
> I want to write a application monitering program to collect the SQL
> Server 2000 performance data,
> such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
> , In Oracle , there are the v$ views and DBA view , which I can find
> the information I interested, the question is , is there a similar suit
> of view in SQL Server 2000 to provide the performance information ?
> Thank you very much, I will be mad by this question, for I have googled
> all the day , but in vain

Look at the table sysperfinfo.

In SQL 2005 this changes drastically. SQL 2005 exposes a lot more
information of this kind.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx