Showing posts with label guys. Show all posts
Showing posts with label guys. Show all posts

Monday, March 26, 2012

I wish upon a new server ....

Howdy guys.

I have the pleasure of assisting a friend with some changes to his
system. One thing he needs is a new SQL setup that will scale.

I was thinking of a quad exon box, 32 bit win2003 enterprise, 12 gig
ram attached to a SAN via fiber with 15,000 rpm drives.

If I need better perfromance, I will add servers on top of the san ...

One reason for the horsepower is we are dealing with a bad old app that
issues dynamic sql for 75% of its processing.

Thoughts ?

And ahead of time, I know sql server is choking itself at some point in
this as well . . . .

Thanks !!> One reason for the horsepower is we are dealing with a bad old app that
> issues dynamic sql for 75% of its processing.

Buying hardware to solve a software issue is probably throwing your money
away, especially if you need to continue to scale in future. How about
investing some of that cash to fix the code first, then see what hardware
you need.

--
David Portas
SQL Server MVP
--

<csomberg@.dwr.com> wrote in message
news:1129765159.626612.115640@.z14g2000cwz.googlegr oups.com...
> Howdy guys.
> I have the pleasure of assisting a friend with some changes to his
> system. One thing he needs is a new SQL setup that will scale.
> I was thinking of a quad exon box, 32 bit win2003 enterprise, 12 gig
> ram attached to a SAN via fiber with 15,000 rpm drives.
> If I need better perfromance, I will add servers on top of the san ...
> One reason for the horsepower is we are dealing with a bad old app that
> issues dynamic sql for 75% of its processing.
> Thoughts ?
> And ahead of time, I know sql server is choking itself at some point in
> this as well . . . .
> Thanks !!|||(csomberg@.dwr.com) writes:
> I have the pleasure of assisting a friend with some changes to his
> system. One thing he needs is a new SQL setup that will scale.
> I was thinking of a quad exon box, 32 bit win2003 enterprise, 12 gig
> ram attached to a SAN via fiber with 15,000 rpm drives.
> If I need better perfromance, I will add servers on top of the san ...
> One reason for the horsepower is we are dealing with a bad old app that
> issues dynamic sql for 75% of its processing.

Beware that this app may not work well with that much memory. If the app
generates lots of dynamic SQL, SQL Server saves the plans for all these
queries in cash. If the queries are similar, they end up in the same
hash bucket, which the net result that looking up if there is an already
cached plan for a query, may take a very long time.

If the app is that civiilzed that it uses parameterised queries that uses
sp_executesql, then this is less likely to be an issue.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||We are re-writing the app but that will take 6 months. The additional
reason for the box is new development and replication as well.

So, thoughts on a new box ?

Me.|||(csomberg@.dwr.com) writes:
> We are re-writing the app but that will take 6 months. The additional
> reason for the box is new development and replication as well.
> So, thoughts on a new box ?

Hardware recommendations in general is not my area. However, I am aware of
the problem of dynamic SQL + lots of memory, which is why I wanted to
alert you.

If you find that the new box behaves unexpectedly poorly, you can keep this
in mind, and rip out some GB of memory until you have fixed the app.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hardware requirements will vary, but a bad application on very good
hardware will just have more room to underperform. It's hard giving
advice without knowing more about your scenario:

1. Are you running an OLAP or OLTP application?
2. You're planning on developing on the same box? Bad idea, but
perhaps I'm misunderstanding what you're saying.
3. How many other databases are you using? What's the overall amount
of data you're looking at? How many users?
4. What's your anticipated growth rate? How critical is this
database, and how will you manage redundancy?
5. What's your current bottleneck? CPU, memory, disk space, network
traffic?

You may want to see if you can pick up an article from SQL Server
magazine by Kevin Kline called Bare Metal Tuning; pretty informative
when it comes to these sorts of questions.

If you want to skip ahead, buy the most expensive box with the biggest
set of hard drives and the most memory you can afford at this time and
the fastest CPU, and then kick yourself hard when the prices drop next
year. :)

Monday, March 19, 2012

I want source control for SQL Server 2000...

Hi guys'n'girls...

I currently work for a company where we develop several large ASP.NET applications which are VERY data centric. But lately we have run into a problem on our developer DB...

On the project I am working on we currenctly have approx. 10 developers working concurrently on the database. That means that we often run into errors caused by two developers working on the same stored procedure, function or trigger so the developer who adds his changes last, overwrites the modifications done by the other developer. The obvious answer is source control for the db, but as far as I can tell this is only available for stored procedures and not for functions or triggers... And even the stored procedure solution isn't very safe because it only works if every developer is editing the procedures through VS.

So what do we do? There must be some solution to this problem... And I'm pretty convinced that we are not the first company to face this problem. Are we doing it the wrong way or do you know another solution?

Thanks in advance!

Try these two urls for options but the manual way to do it is to leave the DDL coding to one or two developers working together and run a stored proc to eliminate duplicates. Hope this helps.


http://www.allisonfamily.org/bill/library/articles/vss-sql-howto/

http://www.sqlservercentral.com/products/bwunder/archiveutility/

Wednesday, March 7, 2012

I need the istance name in my SQL 2000

Hi guys,
how to view the default instance name in my sql server?Hi

Have you tried something like:

SELECT ISNULL(SERVERPROPERTY('InstanceName'), SERVERPROPERTY('MachineName'))

The default instance returns NULL. More information in Books Online.

John

"amnsia" <secondotetidoilmioindirizzocosilospammi@.nondirecaz zate.it> wrote
in message news:camuap$96g$1@.domitilla.aioe.org...
> Hi guys,
> how to view the default instance name in my sql server?

Sunday, February 19, 2012

i need desperate attention........please guys

hello ppl.......

've installed sql 2005 xpress with advanced services......also installed the toolkit that came along..

all 'm interested in is to perform certain data mining operations on the adventureworks db..

;ve also installed the advn works db.........

now here is the prob.......

jus like how the sql online book instructed me i first started off with the datamining tutorial..where i was told to first OPEN BIDS select new PROJECT then make sure that the analysis Services template was selected and then go ahead with selection of the particular sln file....

the problem is that I DON'T SEE ANY ANALYSIS SERVICE TEMPLATE....all i c is a REPORT template..

i really need help guys..... 'm new to .net really feeling helpless...

please hurry guys....

thx a ton..

hanish

Analysis Services and Data Mining are not included with Express (even with Advanced Services).

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||You can download the evaluation edition of SQL Server 2005 which is a 180 day evaluation of Enterprise Edition from http://www.microsoft.com/downloads/details.aspx?FamilyID=6931fa7f-c094-49a2-a050-2d07993566ec|||

thx a ton guys............

ur replies were really helpful......

will bring up new posts ;m sure...n i need u guys ..so hang around

thx again..

hanish