About SQLH2 installation problem .....

hi,
I just tried to install SQL Health and Performance Tool (SQLH2), but when
set the schedule task procedure of the installation, it occured error. After
I read the guide, my server is Window 2000 server, it said it can only
support window server 2003 & window XP(I know that). And the wizard said
press "continue" to ignore that problem and need to set the schedule by
manual, but after I pressed "continue", it still occured that error and no
any other response of it.
So, anyone meet that error as like as me b4?
I feel appreciate anyone can help me ! ^^
Regards,
Tarek ^^'
Tarek's WorkShop
This is a bug in configuration utility.
At this point SQLH2 is installed and configured. You only need to add task
to run it on schedule. You have to do that manually on W2K.
Command to run (int the task) - sqlh2.exe
Thanks
Grigory
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Tarek" <Tarek@.discussions.microsoft.com> wrote in message
news:86829E85-5171-46DD-9B1F-35522EB726AF@.microsoft.com...
> hi,
> I just tried to install SQL Health and Performance Tool (SQLH2), but when
> set the schedule task procedure of the installation, it occured error.
After
> I read the guide, my server is Window 2000 server, it said it can only
> support window server 2003 & window XP(I know that). And the wizard said
> press "continue" to ignore that problem and need to set the schedule by
> manual, but after I pressed "continue", it still occured that error and no
> any other response of it.
> So, anyone meet that error as like as me b4?
> I feel appreciate anyone can help me ! ^^
>
> --
> Regards,
> Tarek ^^'
> --
> Tarek's WorkShop
|||thanks Grigory, let me try it.
Tarek ^^
"Grigory Pogulsky [MS]" wrote:

> This is a bug in configuration utility.
> At this point SQLH2 is installed and configured. You only need to add task
> to run it on schedule. You have to do that manually on W2K.
> Command to run (int the task) - sqlh2.exe
> --
> Thanks
> Grigory
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please reply to the newsgroups only, thanks.
>
> "Tarek" <Tarek@.discussions.microsoft.com> wrote in message
> news:86829E85-5171-46DD-9B1F-35522EB726AF@.microsoft.com...
> After
>
>

About SQL Server

Hi,

Need some help regarding the SQL Server 2005 installation on Windows server 2005.

I have installed the SQL server 2005 on Windods 2003 server.

I have a database of 20 GB. Two of my db tables have about 4 millions of records.

My Sql server has Ram of 2 GB. But As soon as some 10 users fire the queries, SQL server get jammed.It reach the aloocated limit of Max memory.There after It takes too much time to respond.

Can any one suggest me the best configuration parameters for SQL server and for windows server 2003(like virtual memory and paging files etc).

Thanks & Rgds

Vyankatesh

Hi,

I would first check the query plans you are using.
Have you properly indexed your tables? SQL Server takes up memory but that is actually a good thing. If you are having memory pressure you might consider adding more memory to the server but the usage can greatly be reduced by using proper tuned queries.

HTH

|||

#1 -

You could try using -g at startup, to increase resources IF this is from too many databases being open

http://support.microsoft.com/kb/316749/

#2 -

Try trouble shooting with 'DBCC MEMUSAGE' from query analyzer.

#3 -

Look into sp_configure to see if you can make sure your DB is using all 2 GB. I am not sure if SQL 2005 uses 2 GB by default. I can't recall which version uses 1 GB to start. If this is express, it may be capped. I know MSDE 2000 is not capped to 2 GB as to maximum memory.

BY the way, how much did 2005 cost ya ? 10 users ? Bringing it down ?

You have indexes I should hope. Are these users performing update/delete transactions ? Avoid Clustered indexes if you have users performing a lot of updates. Too many unknowns to approach this with a spearheaded plan.

About SQL Server

Hi,

Need some help regarding the SQL Server 2005 installation on Windows server 2005.

I have installed the SQL server 2005 on Windods 2003 server.

I have a database of 20 GB. Two of my db tables have about 4 millions of records.

My Sql server has Ram of 2 GB. But As soon as some 10 users fire the queries, SQL server get jammed.It reach the aloocated limit of Max memory.There after It takes too much time to respond.

Can any one suggest me the best configuration parameters for SQL server and for windows server 2003(like virtual memory and paging files etc).

Thanks & Rgds

Vyankatesh

Hi,

I would first check the query plans you are using.
Have you properly indexed your tables? SQL Server takes up memory but that is actually a good thing. If you are having memory pressure you might consider adding more memory to the server but the usage can greatly be reduced by using proper tuned queries.

HTH

|||

#1 -

You could try using -g at startup, to increase resources IF this is from too many databases being open

http://support.microsoft.com/kb/316749/

#2 -

Try trouble shooting with 'DBCC MEMUSAGE' from query analyzer.

#3 -

Look into sp_configure to see if you can make sure your DB is using all 2 GB. I am not sure if SQL 2005 uses 2 GB by default. I can't recall which version uses 1 GB to start. If this is express, it may be capped. I know MSDE 2000 is not capped to 2 GB as to maximum memory.

BY the way, how much did 2005 cost ya ? 10 users ? Bringing it down ?

You have indexes I should hope. Are these users performing update/delete transactions ? Avoid Clustered indexes if you have users performing a lot of updates. Too many unknowns to approach this with a spearheaded plan.

about security

A lot of time the norton antivirus block an atemp to hack on my computer from an ip called himself nemo

the problem is that after the installation of MSSEE with advanced service I found that the mssee want to connect to a server called nemo and that the admin name is nemo

so whatthat suppose to mean?

ahere is a part of the log file:

Opening 'MachineConfigScope' for [NEMO]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = NEMO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = NEMO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = NEMO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)

Moving to SQL Security forum.|||

I am so sorry I discovered that the system name of my computer is nemo

so the mssee is secure

I am aufully sorry

youssef

About reporting service installation

Hi all,
I have question regarding reporting service installation. Do I need to
install reporting service server software and client software respectively?
Thanks.Hi Iter,
When you say install Server software and client software I am not sure what
you mean, The client see's a web based interface so no specific software is
required, if your talking about the development enviroment, that can be
installed @. the same time... or are your referring to somthing else...
Cheers
Matt
"Iter" wrote:
> Hi all,
> I have question regarding reporting service installation. Do I need to
> install reporting service server software and client software respectively?
> Thanks.
>|||Thank you very much. The thing is that we use report designer in visual
studio.net to develop report, and generally visual studio.net is installed
in client computer. But report manager and report server install in sql
server server side. How to install those respectively. Thanks.
Jerry Mu
"Aussie Matt" wrote:
> Hi Iter,
> When you say install Server software and client software I am not sure what
> you mean, The client see's a web based interface so no specific software is
> required, if your talking about the development enviroment, that can be
> installed @. the same time... or are your referring to somthing else...
> Cheers
> Matt
> "Iter" wrote:
> > Hi all,
> > I have question regarding reporting service installation. Do I need to
> > install reporting service server software and client software respectively?
> > Thanks.
> >