This does not seem like rocket science but I can't find a recommendation
from MS on which uplevel (from defaults) Security Template (file server,
infrastructure server, etc.) is the best baseline starting point for a SQL
install on a W2K3 AD. I realize that mods will be necessary no matter but
since there are 700+ settings having a head start seems like a good thing. I
have created the OU specifically for the SQL server and just need to
configure it's GP including IPSec. I have implemented most of the suggested
Security settings to the install of SQL itself (see prior post).
Any suggestions?
ThanksThe Enterprise - Member Server Template is the template that should be
used. Also, generate a rollback template to help you with your testing.
The High Security Template should not be used.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Showing posts with label level. Show all posts
Showing posts with label level. Show all posts
Tuesday, March 27, 2012
Sunday, February 19, 2012
Benchmark for different edition of sql server 2000
Our company is pondering whether we should upgrade from
standard version to enterprise version. Some high level
people is very concerned about the price.
Is there any good article/whitepaper for this? Something
like industry standard, micrsoft recommendataion,etc?
Thanks.What are your reasons for upgrading? Unless you use the features =specific to Enterprise, it might not be worth the cost.
You can refer to http://www.microsoft.com/sql/techinfo/default.asp
for all sorts of information on SQL Server.
-- Keith
"JZHU" <hzhua16@.hotmail.com> wrote in message =news:005901c39f14$1673b570$a501280a@.phx.gbl...
> Our company is pondering whether we should upgrade from
> standard version to enterprise version. Some high level
> people is very concerned about the price. > Is there any good article/whitepaper for this? Something
> like industry standard, micrsoft recommendataion,etc?
> > Thanks.|||Thanks. My major concern is about the memory. Our database
is around 150-200 GB right now, and support 2000-3000
users. The standard version only support 2G memory. Is it
too little? Currently, when we run the query, most of the
time, it has physical read instead of logical read.
>--Original Message--
>What are your reasons for upgrading? Unless you use the
features specific to Enterprise, it might not be worth the
cost.
>You can refer to
>http://www.microsoft.com/sql/techinfo/default.asp
>for all sorts of information on SQL Server.
>--
>Keith
>
>"JZHU" <hzhua16@.hotmail.com> wrote in message
news:005901c39f14$1673b570$a501280a@.phx.gbl...
>> Our company is pondering whether we should upgrade from
>> standard version to enterprise version. Some high level
>> people is very concerned about the price.
>> Is there any good article/whitepaper for this? Something
>> like industry standard, micrsoft recommendataion,etc?
>> Thanks.
>.
>|||> Thanks. My major concern is about the memory. Our database
> is around 150-200 GB right now, and support 2000-3000
> users. The standard version only support 2G memory. Is it
> too little?
Could be, but it depends of the sweetspot for your memory usage. How about acquiring Developer
Edition and run your benchmark test against this? It is only some $50.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JZHU" <hzhua16@.hotmail.com> wrote in message news:047a01c39f1e$596c2240$a101280a@.phx.gbl...
> Thanks. My major concern is about the memory. Our database
> is around 150-200 GB right now, and support 2000-3000
> users. The standard version only support 2G memory. Is it
> too little? Currently, when we run the query, most of the
> time, it has physical read instead of logical read.
> >--Original Message--
> >What are your reasons for upgrading? Unless you use the
> features specific to Enterprise, it might not be worth the
> cost.
> >
> >You can refer to
> >http://www.microsoft.com/sql/techinfo/default.asp
> >for all sorts of information on SQL Server.
> >
> >--
> >Keith
> >
> >
> >"JZHU" <hzhua16@.hotmail.com> wrote in message
> news:005901c39f14$1673b570$a501280a@.phx.gbl...
> >> Our company is pondering whether we should upgrade from
> >> standard version to enterprise version. Some high level
> >> people is very concerned about the price.
> >> Is there any good article/whitepaper for this? Something
> >> like industry standard, micrsoft recommendataion,etc?
> >>
> >> Thanks.
> >.
> >
standard version to enterprise version. Some high level
people is very concerned about the price.
Is there any good article/whitepaper for this? Something
like industry standard, micrsoft recommendataion,etc?
Thanks.What are your reasons for upgrading? Unless you use the features =specific to Enterprise, it might not be worth the cost.
You can refer to http://www.microsoft.com/sql/techinfo/default.asp
for all sorts of information on SQL Server.
-- Keith
"JZHU" <hzhua16@.hotmail.com> wrote in message =news:005901c39f14$1673b570$a501280a@.phx.gbl...
> Our company is pondering whether we should upgrade from
> standard version to enterprise version. Some high level
> people is very concerned about the price. > Is there any good article/whitepaper for this? Something
> like industry standard, micrsoft recommendataion,etc?
> > Thanks.|||Thanks. My major concern is about the memory. Our database
is around 150-200 GB right now, and support 2000-3000
users. The standard version only support 2G memory. Is it
too little? Currently, when we run the query, most of the
time, it has physical read instead of logical read.
>--Original Message--
>What are your reasons for upgrading? Unless you use the
features specific to Enterprise, it might not be worth the
cost.
>You can refer to
>http://www.microsoft.com/sql/techinfo/default.asp
>for all sorts of information on SQL Server.
>--
>Keith
>
>"JZHU" <hzhua16@.hotmail.com> wrote in message
news:005901c39f14$1673b570$a501280a@.phx.gbl...
>> Our company is pondering whether we should upgrade from
>> standard version to enterprise version. Some high level
>> people is very concerned about the price.
>> Is there any good article/whitepaper for this? Something
>> like industry standard, micrsoft recommendataion,etc?
>> Thanks.
>.
>|||> Thanks. My major concern is about the memory. Our database
> is around 150-200 GB right now, and support 2000-3000
> users. The standard version only support 2G memory. Is it
> too little?
Could be, but it depends of the sweetspot for your memory usage. How about acquiring Developer
Edition and run your benchmark test against this? It is only some $50.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JZHU" <hzhua16@.hotmail.com> wrote in message news:047a01c39f1e$596c2240$a101280a@.phx.gbl...
> Thanks. My major concern is about the memory. Our database
> is around 150-200 GB right now, and support 2000-3000
> users. The standard version only support 2G memory. Is it
> too little? Currently, when we run the query, most of the
> time, it has physical read instead of logical read.
> >--Original Message--
> >What are your reasons for upgrading? Unless you use the
> features specific to Enterprise, it might not be worth the
> cost.
> >
> >You can refer to
> >http://www.microsoft.com/sql/techinfo/default.asp
> >for all sorts of information on SQL Server.
> >
> >--
> >Keith
> >
> >
> >"JZHU" <hzhua16@.hotmail.com> wrote in message
> news:005901c39f14$1673b570$a501280a@.phx.gbl...
> >> Our company is pondering whether we should upgrade from
> >> standard version to enterprise version. Some high level
> >> people is very concerned about the price.
> >> Is there any good article/whitepaper for this? Something
> >> like industry standard, micrsoft recommendataion,etc?
> >>
> >> Thanks.
> >.
> >
Sunday, February 12, 2012
beginner here help me
hello friends,
I have been asked to work on crystal reports on vb6.0. I want very begginner level examples to understand and learn crystal reports.
any help will be appreciated,
varshaVarsha,
See Crystal Reports help for better understanding. Be strong in Formula, Parameter concepts. Refer this also http://www.uk.businessobjects.com/products/reporting/crystalreports/default.asp
I have been asked to work on crystal reports on vb6.0. I want very begginner level examples to understand and learn crystal reports.
any help will be appreciated,
varshaVarsha,
See Crystal Reports help for better understanding. Be strong in Formula, Parameter concepts. Refer this also http://www.uk.businessobjects.com/products/reporting/crystalreports/default.asp
Begin Tran ...... Commit Tran
What is the need of BEGIN TRAN...COMMIT TRAN? Also why you are setting Transaction isolation level to SERIALIZABLE?
Hi ,
Go through the sql online books.|||
Refer
http://msdn2.microsoft.com/en-us/li...83(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/ms173763.aspx
http://www.mssqlcity.com/Articles/General/TIL.htm|||
simple to roll back the qry process done
Quote:
Originally Posted by sajithamol
What is the need of BEGIN TRAN...COMMIT TRAN? Also why you are setting Transaction isolation level to SERIALIZABLE?
Hi ,
Go through the sql online books.|||
Quote:
Originally Posted by sajithamol
What is the need of BEGIN TRAN...COMMIT TRAN? Also why you are setting Transaction isolation level to SERIALIZABLE?
Refer
http://msdn2.microsoft.com/en-us/li...83(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/ms173763.aspx
http://www.mssqlcity.com/Articles/General/TIL.htm|||
Quote:
Originally Posted by sajithamol
What is the need of BEGIN TRAN...COMMIT TRAN? Also why you are setting Transaction isolation level to SERIALIZABLE?
simple to roll back the qry process done
Subscribe to:
Posts (Atom)