SQL About AMO: consuming

Showing posts with label consuming. Show all posts

Thursday, March 8, 2012

about writes/sec SQL server

Hi Guys,
Do you know how many writes/sec SQL server is capable of performing
generally? Trying to work out what % of a DB we would be consuming. ThanksProbably many more than you will even need. But it is usually not SQL
Server that is the bottle neck. It is mostly the hardware that will
determine how many writes per second you can do.
--
Andrew J. Kelly SQL MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
> Hi Guys,
> Do you know how many writes/sec SQL server is capable of performing
> generally? Trying to work out what % of a DB we would be consuming. Thanks
>|||How many transactions the sql server can handle for a minutes. Thanks.
"Andrew J. Kelly" wrote:
> Probably many more than you will even need. But it is usually not SQL
> Server that is the bottle neck. It is mostly the hardware that will
> determine how many writes per second you can do.
> --
> Andrew J. Kelly SQL MVP
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
> > Hi Guys,
> > Do you know how many writes/sec SQL server is capable of performing
> > generally? Trying to work out what % of a DB we would be consuming. Thanks
> >
> >
>
>|||try to navigate to www.tpc.org: you'll find a lot of different answers.
The number of transactions/min depends on a lot of factrors:
- Hardware
- Infrastructure
- OS
- physical and logical design of the DB
- logical design and implementation of the transaction
- etc.
Usualy any RDBMS is implemented to give the most efficiency, but...
Gilberto
"Iter" wrote:
> How many transactions the sql server can handle for a minutes. Thanks.
>
> "Andrew J. Kelly" wrote:
> > Probably many more than you will even need. But it is usually not SQL
> > Server that is the bottle neck. It is mostly the hardware that will
> > determine how many writes per second you can do.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > "Iter" <Iter@.discussions.microsoft.com> wrote in message
> > news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
> > > Hi Guys,
> > > Do you know how many writes/sec SQL server is capable of performing
> > > generally? Trying to work out what % of a DB we would be consuming. Thanks
> > >
> > >
> >
> >
> >|||Like I said it is mainly up to the hardware and how the application and
schema were developed. I have worked on SQL Servers that do over 60K
transactions per second. The TPC link that was given would be a good
resource but that does nothing to show how much your system will do.
--
Andrew J. Kelly SQL MVP
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:098E0931-DD8C-403F-8837-5091D21AE42A@.microsoft.com...
> How many transactions the sql server can handle for a minutes. Thanks.
>
> "Andrew J. Kelly" wrote:
>> Probably many more than you will even need. But it is usually not SQL
>> Server that is the bottle neck. It is mostly the hardware that will
>> determine how many writes per second you can do.
>> --
>> Andrew J. Kelly SQL MVP
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
>> > Hi Guys,
>> > Do you know how many writes/sec SQL server is capable of performing
>> > generally? Trying to work out what % of a DB we would be consuming.
>> > Thanks
>> >
>> >
>>|||"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:098E0931-DD8C-403F-8837-5091D21AE42A@.microsoft.com...
> How many transactions the sql server can handle for a minutes. Thanks.
How big are your transactions?
Are you committing 5 bytes or 5 gigabytes?
How many disks do you have?
How fast are they?
Quite seriously, your question is really a bit open ended.
Note, even with the TPC benchmarks that Andrew pointed you towards, that's
really a matter of "how much money you want to spend."
With more money, MS could probably post even better numbers. But until
someone betters them enough, they won't bother.
>
> "Andrew J. Kelly" wrote:
>> Probably many more than you will even need. But it is usually not SQL
>> Server that is the bottle neck. It is mostly the hardware that will
>> determine how many writes per second you can do.
>> --
>> Andrew J. Kelly SQL MVP
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
>> > Hi Guys,
>> > Do you know how many writes/sec SQL server is capable of performing
>> > generally? Trying to work out what % of a DB we would be consuming.
>> > Thanks
>> >
>> >
>>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Simple answer: enough for your needs - given sufficient hardware. :-) And
it doesn't take a kajillion dollars worth of hardware to get REALLY good
performance either!
--
TheSQLGuru
President
Indicium Resources, Inc.
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:098E0931-DD8C-403F-8837-5091D21AE42A@.microsoft.com...
> How many transactions the sql server can handle for a minutes. Thanks.
>
> "Andrew J. Kelly" wrote:
>> Probably many more than you will even need. But it is usually not SQL
>> Server that is the bottle neck. It is mostly the hardware that will
>> determine how many writes per second you can do.
>> --
>> Andrew J. Kelly SQL MVP
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:33DBA316-4AE8-49D0-A7EE-D49F8ECD9E7D@.microsoft.com...
>> > Hi Guys,
>> > Do you know how many writes/sec SQL server is capable of performing
>> > generally? Trying to work out what % of a DB we would be consuming.
>> > Thanks
>> >
>> >
>>

Thursday, February 16, 2012

About my way to insert rows.

I have heard that the most time consuming task into a DB is the when we use
the Insert Statatement,
Is that true?
Ok I have an application that sends from 10 to 500 rows to the DB, those
rows are compared again a fixed value and then they are inserted to the DB i
f
the comparison is ok.
I would like to do all that inside the DB (a SP) but I don’t know how, so
I
created a WebService to do that, my point is that I’m not inserting row by
row instead I hold the rows in a Dataset (memory) and later I make one big
insert to the DB.
My question is should I leave that code like this or should go to the DB in
order to insert row by row to gain some performance?
Can you think a better way to do that, because that is the heart of my app
and I want to minimize the time it takes.
Thnks.
Kenny M.Hi Kenny
Please let me know what kind of comparision is that u are doing before
inserting rows into your database.
Just try avoiding bringing data to the front-end if its only a validation
part.
You can write a query as:
INSERT INTO <TABLE>
SELECT <Columns>
FROM <another table>
<WHERE Condition>
alternatively you can also write INSTEAD OF Triggers, if you want to check
the records before they are inserted
hope this will solve the problem
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Kenny M." wrote:

> I have heard that the most time consuming task into a DB is the when we us
e
> the Insert Statatement,
> Is that true?
> Ok I have an application that sends from 10 to 500 rows to the DB, those
> rows are compared again a fixed value and then they are inserted to the DB
if
> the comparison is ok.
> I would like to do all that inside the DB (a SP) but I don’t know how, s
o I
> created a WebService to do that, my point is that I’m not inserting row
by
> row instead I hold the rows in a Dataset (memory) and later I make one big
> insert to the DB.
> My question is should I leave that code like this or should go to the DB i
n
> order to insert row by row to gain some performance?
> Can you think a better way to do that, because that is the heart of my app
> and I want to minimize the time it takes.
> Thnks.
> --
> Kenny M.|||Hi, Well
In order to understand it better, the table Category is like this
CategoryID Number SetAmount
1 0 1000
1 ... ...
1 999 2000 For each Category there
are 1000 numbers
2 0 200
2 ... ...
2 999 3000
.. ... ...
n 0 - 999 ...
e.g
I send 100 rows to the method . The rows are like this
ID,DATETIME, NUMBER,AMOUNT,CATEGORYID
For each row I have to go to the categorytable look for the CATEGORYID then
look for the NUMBER and ask if the AMOUNT is > SetAmount. If so I have to
Insert the Whole Record into another table.
At this time I'm doing that process inside a WService.
I'm not inserting row by row, instead I'm saving the valid row in a DataSet
to later Insert them to a Table.(Using Fill method)
Any sug.
thks.
Kenny M.
"Chandra" wrote:
> Hi Kenny
> Please let me know what kind of comparision is that u are doing before
> inserting rows into your database.
> Just try avoiding bringing data to the front-end if its only a validation
> part.
>
> You can write a query as:
> INSERT INTO <TABLE>
> SELECT <Columns>
> FROM <another table>
> <WHERE Condition>
> alternatively you can also write INSTEAD OF Triggers, if you want to check
> the records before they are inserted
> hope this will solve the problem
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Kenny M." wrote:
>

Thursday, March 8, 2012

about writes/sec SQL server

about writes/sec SQL server

about writes/sec SQL server

Thursday, February 16, 2012

About my way to insert rows.

About my way to insert rows.

SQL About AMO

Blog Archive

About Me