Consolidation Query: servers

Showing posts with label servers. Show all posts

Tuesday, March 20, 2012

Conversation Groups

I am thinking of updating my SQL monitoring application to use Service Broker.

Right now I loop through my list of servers performing various checks on each server. Things like 'check last database backup', 'check for new databases', 'check for server restart'. I loop through, one server at a time, doing one check at a time. The more servers I have the longer it is taking.

So, I want to multi-thread the servers, but single-thread the checks on each individual server. This way I can check say, 5 servers at a time, but on each server I will only do one check at a time. This way I won't flood an individual server with multiple checks.

Is this possible? It looks like Conversation groups might be the way to go but I'm not sure.

Conversatiuon groups are always local, as in no conversation group info ever goes across the wire with a message. The purpose of conversation groups is to lock together logically related conversations.

To have each server do only one check at a time, is eanough to restrict the activated max count to 1. This way there's at most one instance of the activated procedure doing one check. Multiple requests can be sent to the same server, they'll simply be queued up and wait their turn.

The problem you describe can also be aproached as a pub-sub problem (see https://blogs.msdn.com/remusrusanu/archive/2005/12/12/502942.aspx). The publisher (your central administrative service) publishes 'check requests'. All instances you monitor are subscribed to this publisher and receive the request, perform the check and report the result.

HTH,
~ Remus

|||

Thanks for the reply.

I don't think I gave you enough info. All my monitoring processes are running on the same server. I connect out to the 'monitored' servers using linked servers. I can't have the queues on the 'monitored' server as most of them are SQL 2000.

The whole monitoring is run from one SQL 2005 server.

I will take a look at the article you mentioned.

Thanks

Saturday, February 25, 2012

CONTAINS search not working on live server

Friday, February 24, 2012

CONTAINS search not working on live server

Hi
I'm dealing with a company that have 3 web servers a test, staging and live.
All these servers are sql server 2000 and are situated offsite. I do not
have dirrect access to them, I have to send them email with scripts when
things need changing.
The website works on the test and the staging but for some reason the search
doesn't work on the live server. The search uses CONTAINS and the catalog
seem to be set up correctly on all three servers. The search works in the
sence that it doesn't error but all it returns is zero rows.
Any clues?
Cheers
JamesIt is possible to have a full-text index defined, but the database itself
not be enabled for full-text indexing. I would expect an error with this
circumstance.
Also, make sure that the index is actually populated. The populate process
has been known to fail.
And, just for small measure, make sure that you are not including noise
words in the search. This can raise a 'nothing but noise words' error even
though there are also non-noise words. (Sigh.)
Russell Fields
"James Brett" <james.brett@.unified.co.uk> wrote in message
news:%232GWGJHsEHA.516@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm dealing with a company that have 3 web servers a test, staging and
live.
> All these servers are sql server 2000 and are situated offsite. I do not
> have dirrect access to them, I have to send them email with scripts when
> things need changing.
> The website works on the test and the staging but for some reason the
search
> doesn't work on the live server. The search uses CONTAINS and the catalog
> seem to be set up correctly on all three servers. The search works in the
> sence that it doesn't error but all it returns is zero rows.
> Any clues?
> Cheers
> James
>|||has a full population been done?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"James Brett" <james.brett@.unified.co.uk> wrote in message
news:%232GWGJHsEHA.516@.TK2MSFTNGP09.phx.gbl...
> Hi
> I'm dealing with a company that have 3 web servers a test, staging and
live.
> All these servers are sql server 2000 and are situated offsite. I do not
> have dirrect access to them, I have to send them email with scripts when
> things need changing.
> The website works on the test and the staging but for some reason the
search
> doesn't work on the live server. The search uses CONTAINS and the catalog
> seem to be set up correctly on all three servers. The search works in the
> sence that it doesn't error but all it returns is zero rows.
> Any clues?
> Cheers
> James
>|||I've been assured it has.
Is there a system query that will tell me the number of rows in the catalog?
Cheers
James
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OEaqk$JsEHA.896@.TK2MSFTNGP12.phx.gbl...
> has a full population been done?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "James Brett" <james.brett@.unified.co.uk> wrote in message
> news:%232GWGJHsEHA.516@.TK2MSFTNGP09.phx.gbl...
> > Hi
> >
> > I'm dealing with a company that have 3 web servers a test, staging and
> live.
> > All these servers are sql server 2000 and are situated offsite. I do not
> > have dirrect access to them, I have to send them email with scripts when
> > things need changing.
> >
> > The website works on the test and the staging but for some reason the
> search
> > doesn't work on the live server. The search uses CONTAINS and the
catalog
> > seem to be set up correctly on all three servers. The search works in
the
> > sence that it doesn't error but all it returns is zero rows.
> >
> > Any clues?
> >
> > Cheers
> > James
> >
> >
>|||try this
select FulltextCatalogProperty('CatalogName', 'UniqueKeyCount')
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"James Brett" <james.brett@.unified.co.uk> wrote in message
news:O6jdEoPsEHA.1988@.TK2MSFTNGP11.phx.gbl...
> I've been assured it has.
> Is there a system query that will tell me the number of rows in the
catalog?
> Cheers
> James
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OEaqk$JsEHA.896@.TK2MSFTNGP12.phx.gbl...
> > has a full population been done?
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "James Brett" <james.brett@.unified.co.uk> wrote in message
> > news:%232GWGJHsEHA.516@.TK2MSFTNGP09.phx.gbl...
> > > Hi
> > >
> > > I'm dealing with a company that have 3 web servers a test, staging and
> > live.
> > > All these servers are sql server 2000 and are situated offsite. I do
not
> > > have dirrect access to them, I have to send them email with scripts
when
> > > things need changing.
> > >
> > > The website works on the test and the staging but for some reason the
> > search
> > > doesn't work on the live server. The search uses CONTAINS and the
> catalog
> > > seem to be set up correctly on all three servers. The search works in
> the
> > > sence that it doesn't error but all it returns is zero rows.
> > >
> > > Any clues?
> > >
> > > Cheers
> > > James
> > >
> > >
> >
> >
>|||That's the one
Thanks
James
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OWvuOESsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> try this
> select FulltextCatalogProperty('CatalogName', 'UniqueKeyCount')
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "James Brett" <james.brett@.unified.co.uk> wrote in message
> news:O6jdEoPsEHA.1988@.TK2MSFTNGP11.phx.gbl...
> > I've been assured it has.
> >
> > Is there a system query that will tell me the number of rows in the
> catalog?
> >
> > Cheers
> > James
> >
> > "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> > news:OEaqk$JsEHA.896@.TK2MSFTNGP12.phx.gbl...
> > > has a full population been done?
> > >
> > > --
> > > Hilary Cotter
> > > Looking for a SQL Server replication book?
> > > http://www.nwsu.com/0974973602.html
> > >
> > >
> > > "James Brett" <james.brett@.unified.co.uk> wrote in message
> > > news:%232GWGJHsEHA.516@.TK2MSFTNGP09.phx.gbl...
> > > > Hi
> > > >
> > > > I'm dealing with a company that have 3 web servers a test, staging
and
> > > live.
> > > > All these servers are sql server 2000 and are situated offsite. I do
> not
> > > > have dirrect access to them, I have to send them email with scripts
> when
> > > > things need changing.
> > > >
> > > > The website works on the test and the staging but for some reason
the
> > > search
> > > > doesn't work on the live server. The search uses CONTAINS and the
> > catalog
> > > > seem to be set up correctly on all three servers. The search works
in
> > the
> > > > sence that it doesn't error but all it returns is zero rows.
> > > >
> > > > Any clues?
> > > >
> > > > Cheers
> > > > James
> > > >
> > > >
> > >
> > >
> >
> >
>|||Also,
Try this in order to see if the Index is populated ...
select FulltextCatalogProperty('CatalogName', 'ItemCount').
If you do not have values and you attempt to start Change-Tracking and you
still
have 0 fro an ItemCount after trying to populate the Index, I have actually
found that right-clicking on the catalog and selecting Properties, a defined
file name should be evident...SQL000050001 or something like that.
At this point, what I have done in the past is simply navigate to defined
file location and move it to another directory "Only after stopping the
MS-Search" and then restart MS-Search.
Rebuild and Re-Populate !!!
Anthony E. Castro
MCP, MCDBA
"James Brett" wrote:
> That's the one
> Thanks
> James
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OWvuOESsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> > try this
> >
> > select FulltextCatalogProperty('CatalogName', 'UniqueKeyCount')
> >
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "James Brett" <james.brett@.unified.co.uk> wrote in message
> > news:O6jdEoPsEHA.1988@.TK2MSFTNGP11.phx.gbl...
> > > I've been assured it has.
> > >
> > > Is there a system query that will tell me the number of rows in the
> > catalog?
> > >
> > > Cheers
> > > James
> > >
> > > "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> > > news:OEaqk$JsEHA.896@.TK2MSFTNGP12.phx.gbl...
> > > > has a full population been done?
> > > >
> > > > --
> > > > Hilary Cotter
> > > > Looking for a SQL Server replication book?
> > > > http://www.nwsu.com/0974973602.html
> > > >
> > > >
> > > > "James Brett" <james.brett@.unified.co.uk> wrote in message
> > > > news:%232GWGJHsEHA.516@.TK2MSFTNGP09.phx.gbl...
> > > > > Hi
> > > > >
> > > > > I'm dealing with a company that have 3 web servers a test, staging
> and
> > > > live.
> > > > > All these servers are sql server 2000 and are situated offsite. I do
> > not
> > > > > have dirrect access to them, I have to send them email with scripts
> > when
> > > > > things need changing.
> > > > >
> > > > > The website works on the test and the staging but for some reason
> the
> > > > search
> > > > > doesn't work on the live server. The search uses CONTAINS and the
> > > catalog
> > > > > seem to be set up correctly on all three servers. The search works
> in
> > > the
> > > > > sence that it doesn't error but all it returns is zero rows.
> > > > >
> > > > > Any clues?
> > > > >
> > > > > Cheers
> > > > > James
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

CONTAINS search not working on live server

Friday, February 10, 2012

Consolidation question

I have to move a database from Server A to Server B. I have checked the space
and CPU utilization on both the servers. The database size is 5 GB and there
are 50 concurrent users.
Server A - source server
CPU utilization - <25 %
Available space - 80 Gb
Memory - 2 GB
Memory used by sqlserver.exe - 1800 MB
Memory configured for dynamic allocation by sql server upto 2GB
Server B - destination server
CPU utilization - <10 %
Available space - 80 Gb
Memory - 1795 MB
Memory used by sqlserver.exe - 1500 MB
Memory configured for dynamic allocation by sql server upto 1795 MB
How do I find out if the memory is going to be sufficient after the move? I
ma thinking of reducing the memory allocated to sql servers on both Server A
and Server B to just 1 GB and see the performance of both the servers. If
tehy perform OK at reduced memory then I will assume the memory on
destination Server B will be good enough for the new database. Any insight
will be highly appreciated. Thanks.sharman,
SQL Server uses as much space as it can in its address space unless it has
to give up memory to other processes. But this memory need is not doubled
when you bring another database and 50 users online. The impact on memory
is probably rather small. Certainly, I don't think that restricting memory
on the two servers will give you a meaningful measure for what will happen
when they are brought together on one server.
Of course, you are expecting CPU utilization to go up. Something else that
you should check on each server is the SQL Servers: Buffer Manager \ Page
Life Expectancy. If they are consistently under 300 seconds, that may
indicate that there is too little memory for the active buffer contents,
which will mean more I/O and CPU.
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:96430D73-D40A-4961-A95C-00C7E2F0CD89@.microsoft.com...
>I have to move a database from Server A to Server B. I have checked the
>space
> and CPU utilization on both the servers. The database size is 5 GB and
> there
> are 50 concurrent users.
> Server A - source server
> CPU utilization - <25 %
> Available space - 80 Gb
> Memory - 2 GB
> Memory used by sqlserver.exe - 1800 MB
> Memory configured for dynamic allocation by sql server upto 2GB
> Server B - destination server
> CPU utilization - <10 %
> Available space - 80 Gb
> Memory - 1795 MB
> Memory used by sqlserver.exe - 1500 MB
> Memory configured for dynamic allocation by sql server upto 1795 MB
> How do I find out if the memory is going to be sufficient after the move?
> I
> ma thinking of reducing the memory allocated to sql servers on both Server
> A
> and Server B to just 1 GB and see the performance of both the servers. If
> tehy perform OK at reduced memory then I will assume the memory on
> destination Server B will be good enough for the new database. Any insight
> will be highly appreciated. Thanks.|||Hi Russell,
Thanks for the info. I did a quick check of Page Life Expectancy on both the
servers. These are the typical values that I found.
Sever to which the db will be moved = 33270 (average)
Server on which the db currently resides = varies between 282 to 378
"Russell Fields" wrote:
> sharman,
> SQL Server uses as much space as it can in its address space unless it has
> to give up memory to other processes. But this memory need is not doubled
> when you bring another database and 50 users online. The impact on memory
> is probably rather small. Certainly, I don't think that restricting memory
> on the two servers will give you a meaningful measure for what will happen
> when they are brought together on one server.
> Of course, you are expecting CPU utilization to go up. Something else that
> you should check on each server is the SQL Servers: Buffer Manager \ Page
> Life Expectancy. If they are consistently under 300 seconds, that may
> indicate that there is too little memory for the active buffer contents,
> which will mean more I/O and CPU.
> RLF
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:96430D73-D40A-4961-A95C-00C7E2F0CD89@.microsoft.com...
> >I have to move a database from Server A to Server B. I have checked the
> >space
> > and CPU utilization on both the servers. The database size is 5 GB and
> > there
> > are 50 concurrent users.
> >
> > Server A - source server
> > CPU utilization - <25 %
> > Available space - 80 Gb
> > Memory - 2 GB
> > Memory used by sqlserver.exe - 1800 MB
> > Memory configured for dynamic allocation by sql server upto 2GB
> >
> > Server B - destination server
> > CPU utilization - <10 %
> > Available space - 80 Gb
> > Memory - 1795 MB
> > Memory used by sqlserver.exe - 1500 MB
> > Memory configured for dynamic allocation by sql server upto 1795 MB
> >
> > How do I find out if the memory is going to be sufficient after the move?
> > I
> > ma thinking of reducing the memory allocated to sql servers on both Server
> > A
> > and Server B to just 1 GB and see the performance of both the servers. If
> > tehy perform OK at reduced memory then I will assume the memory on
> > destination Server B will be good enough for the new database. Any insight
> > will be highly appreciated. Thanks.
>
>|||Sharman,
It looks like you are on the low, but acceptable side of Page Life
Expectancy. However, reviewing your notes says that you are moving to the
server with a couple hundred megabytes less memory. So you may find
yourself experiencing some memory pressure issues when the memory load moves
machines.
It looks like you are fine with your CPU for the time being, but it would be
good to bump up your memory a bit, if you can.
You did not mention which version of OS and SQL Server you are running, but
those will make a difference in your memory options.
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:A552585E-485D-4149-B797-A014B1E2BAAA@.microsoft.com...
> Hi Russell,
> Thanks for the info. I did a quick check of Page Life Expectancy on both
> the
> servers. These are the typical values that I found.
> Sever to which the db will be moved = 33270 (average)
> Server on which the db currently resides = varies between 282 to 378
> "Russell Fields" wrote:
>> sharman,
>> SQL Server uses as much space as it can in its address space unless it
>> has
>> to give up memory to other processes. But this memory need is not
>> doubled
>> when you bring another database and 50 users online. The impact on
>> memory
>> is probably rather small. Certainly, I don't think that restricting
>> memory
>> on the two servers will give you a meaningful measure for what will
>> happen
>> when they are brought together on one server.
>> Of course, you are expecting CPU utilization to go up. Something else
>> that
>> you should check on each server is the SQL Servers: Buffer Manager \ Page
>> Life Expectancy. If they are consistently under 300 seconds, that may
>> indicate that there is too little memory for the active buffer contents,
>> which will mean more I/O and CPU.
>> RLF
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:96430D73-D40A-4961-A95C-00C7E2F0CD89@.microsoft.com...
>> >I have to move a database from Server A to Server B. I have checked the
>> >space
>> > and CPU utilization on both the servers. The database size is 5 GB and
>> > there
>> > are 50 concurrent users.
>> >
>> > Server A - source server
>> > CPU utilization - <25 %
>> > Available space - 80 Gb
>> > Memory - 2 GB
>> > Memory used by sqlserver.exe - 1800 MB
>> > Memory configured for dynamic allocation by sql server upto 2GB
>> >
>> > Server B - destination server
>> > CPU utilization - <10 %
>> > Available space - 80 Gb
>> > Memory - 1795 MB
>> > Memory used by sqlserver.exe - 1500 MB
>> > Memory configured for dynamic allocation by sql server upto 1795 MB
>> >
>> > How do I find out if the memory is going to be sufficient after the
>> > move?
>> > I
>> > ma thinking of reducing the memory allocated to sql servers on both
>> > Server
>> > A
>> > and Server B to just 1 GB and see the performance of both the servers.
>> > If
>> > tehy perform OK at reduced memory then I will assume the memory on
>> > destination Server B will be good enough for the new database. Any
>> > insight
>> > will be highly appreciated. Thanks.
>>

Consolidation of server

We have two production servers and SQL is running on both servers. The
databses in two production srevers has same name. I am in process of
consolidating server. I have to move all the datbases to another sql server
in the other box. But now i have a problem. Since dtabase name is same i am
stuck can any body help me to sort this out.
Thanks ....You can install a separate named instance on the server, therefore you can
keep the same dbname.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_259u.asp
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
news:861FD285-C52D-4369-9FFE-419F99028232@.microsoft.com...
> We have two production servers and SQL is running on both servers. The
> databses in two production srevers has same name. I am in process of
> consolidating server. I have to move all the datbases to another sql
> server
> in the other box. But now i have a problem. Since dtabase name is same i
> am
> stuck can any body help me to sort this out.
> Thanks ....|||Thanks so much jens. I installed it. But i do i switch over between 2
instances. Does the same enterprise manger works.
"Jens SÃ¼Ã?meyer" wrote:
> You can install a separate named instance on the server, therefore you can
> keep the same dbname.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_259u.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:861FD285-C52D-4369-9FFE-419F99028232@.microsoft.com...
> > We have two production servers and SQL is running on both servers. The
> > databses in two production srevers has same name. I am in process of
> > consolidating server. I have to move all the datbases to another sql
> > server
> > in the other box. But now i have a problem. Since dtabase name is same i
> > am
> > stuck can any body help me to sort this out.
> >
> > Thanks ....
>
>|||YOu habe to tregister the server within the Enterrise Manager, the
servername of a named instance is
Servername\InstanceName
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
news:509CBA13-244E-4C6C-BC15-1E9789FB2AAE@.microsoft.com...
> Thanks so much jens. I installed it. But i do i switch over between 2
> instances. Does the same enterprise manger works.
> "Jens Süßmeyer" wrote:
>> You can install a separate named instance on the server, therefore you
>> can
>> keep the same dbname.
>>
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_259u.asp
>> HTH, Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:861FD285-C52D-4369-9FFE-419F99028232@.microsoft.com...
>> > We have two production servers and SQL is running on both servers. The
>> > databses in two production srevers has same name. I am in process of
>> > consolidating server. I have to move all the datbases to another sql
>> > server
>> > in the other box. But now i have a problem. Since dtabase name is same
>> > i
>> > am
>> > stuck can any body help me to sort this out.
>> >
>> > Thanks ....
>>

Tuesday, March 20, 2012

Conversation Groups

Saturday, February 25, 2012

CONTAINS search not working on live server

CONTAINS search not working on live server

Friday, February 24, 2012

CONTAINS search not working on live server

CONTAINS search not working on live server

Friday, February 10, 2012

Consolidation question

Consolidation of server

Consolidation of server

Consolidation of server

Consolidation Query

Blog Archive

About Me