Sql ANSI Padding: varying

显示标签为“varying”的博文。显示所有博文

2012年3月19日星期一

Any way to be notified if database grows?

Our databases are configured for automatic growth by varying increments of MB.
Is there a way (an alert?) to find out when the growth has actualy happened?
Our customers are complaining of "random" poor performance - I would like to
rule out database growth.
TYIAYou can catch it using a Profiler trace. And probably also using an event notification (see CREATE
EVENT NOTIFICATION), if you are on 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:EA3B1E1E-9A31-4C7D-B3F0-89B32CAD431F@.microsoft.com...
> Our databases are configured for automatic growth by varying increments of MB.
> Is there a way (an alert?) to find out when the growth has actualy happened?
> Our customers are complaining of "random" poor performance - I would like to
> rule out database growth.
> TYIA|||Thank you for your response.
Unfortunately, we are sill on 2000.
Are there any alerts SQL that would capture this?
Any way to write to the Event logs?
I don't know when it will happen and can't have a trace running 24 x 7.
Thank you .
"Tibor Karaszi" wrote:
> You can catch it using a Profiler trace. And probably also using an event notification (see CREATE
> EVENT NOTIFICATION), if you are on 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
> news:EA3B1E1E-9A31-4C7D-B3F0-89B32CAD431F@.microsoft.com...
> > Our databases are configured for automatic growth by varying increments of MB.
> > Is there a way (an alert?) to find out when the growth has actualy happened?
> > Our customers are complaining of "random" poor performance - I would like to
> > rule out database growth.
> >
> > TYIA
>|||No and no, I'm afraid. It isn't a big deal to have a *server side* profiler trace running
continually. Of you can poll for the file size as frequently as you need and based on that log when
you notice a change in size.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:3AC5067C-9E8D-4564-BDD9-1F365BB8661D@.microsoft.com...
> Thank you for your response.
> Unfortunately, we are sill on 2000.
> Are there any alerts SQL that would capture this?
> Any way to write to the Event logs?
> I don't know when it will happen and can't have a trace running 24 x 7.
> Thank you .
> "Tibor Karaszi" wrote:
>> You can catch it using a Profiler trace. And probably also using an event notification (see
>> CREATE
>> EVENT NOTIFICATION), if you are on 2005.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
>> news:EA3B1E1E-9A31-4C7D-B3F0-89B32CAD431F@.microsoft.com...
>> > Our databases are configured for automatic growth by varying increments of MB.
>> > Is there a way (an alert?) to find out when the growth has actualy happened?
>> > Our customers are complaining of "random" poor performance - I would like to
>> > rule out database growth.
>> >
>> > TYIA
>>|||On Aug 15, 9:45 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> No and no, I'm afraid. It isn't a big deal to have a *server side* profiler trace running
> continually. Of you can poll for the file size as frequently as you need and based on that log when
> you notice a change in size.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "RobinMC" <Robi...@.discussions.microsoft.com> wrote in message
> news:3AC5067C-9E8D-4564-BDD9-1F365BB8661D@.microsoft.com...
>
> > Thank you for your response.
> > Unfortunately, we are sill on 2000.
> > Are there any alerts SQL that would capture this?
> > Any way to write to the Event logs?
> > I don't know when it will happen and can't have a trace running 24 x 7.
> > Thank you .
> > "Tibor Karaszi" wrote:
> >> You can catch it using a Profiler trace. And probably also using an event notification (see
> >> CREATE
> >> EVENT NOTIFICATION), if you are on 2005.
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >>http://www.karaszi.com/sqlserver/default.asp
> >>http://sqlblog.com/blogs/tibor_karaszi
> >> "RobinMC" <Robi...@.discussions.microsoft.com> wrote in message
> >>news:EA3B1E1E-9A31-4C7D-B3F0-89B32CAD431F@.microsoft.com...
> >> > Our databases are configured for automatic growth by varying increments of MB.
> >> > Is there a way (an alert?) to find out when the growth has actualy happened?
> >> > Our customers are complaining of "random" poor performance - I would like to
> >> > rule out database growth.
> >> > TYIA- Hide quoted text -
> - Show quoted text -
Instead of a profiler trace, start a perfmon (administrative tools-
>performance) trace on the server, tracing the following counters:
Performance Object: MsSQL:Databases
Counters: Data File Size KB, Log File Size KB
Instances: Select the appropriate database(s) that you'd like to
collect.
A relatively low sampling interval (once per every minute or few)
should be enough to give you the data that you're looking for.
Whenever any of these counters increase, you'll know that a file
growth occured and the amount that the file was expanded.
MS|||On Wed, 15 Aug 2007 13:10:01 -0700, RobinMC
<RobinMC@.discussions.microsoft.com> wrote:
>Our databases are configured for automatic growth by varying increments of MB.
>Is there a way (an alert?) to find out when the growth has actualy happened?
>Our customers are complaining of "random" poor performance - I would like to
>rule out database growth.
You could write a short app that checks the .mdf filesize every five
seconds or so.
J.

Any way to be notified if database grows?

2012年2月11日星期六

Anti-Virus on SQL Server? - Merits and Arguments?

Do any of you run any anti-virus software on your SQL Servers -- for
dedicated SQL Server boxes?
We have some varying views within our organization on what approach to take
to protecting the SQL Server.
We do not have any file shares, or IIS or any unneeded services running on
our dedicated SQL Server's -- thus I guess I do not see the merit of using
anti-virus software on the SQL Server itself when the attach vectors are
fairly minimized.
Our SQL Servers are all internal, no DMZ, no external. The only major
vulnerability would be internal threats (which are minimized by other
internal controls, i.e. AV at the desktop, etc.).
Is patch management, properly configured SQL Server security, and a good
understanding of what services are open on the particular box enough to
protect against 90-95% of the vulnerabilities that may exist?
Thanks for your opinion,
Aaron"Aaron Vance" <thisisnttheemailyourlookingfor@.nospam.com> wrote in message
news:u$mL3kF4DHA.3576@.TK2MSFTNGP11.phx.gbl...

quote:

> Do any of you run any anti-virus software on your SQL Servers -- for
> dedicated SQL Server boxes?

We run anti-virus software on ALL of our servers regardless of role.

quote:

> We have some varying views within our organization on what approach to

take

quote:

> to protecting the SQL Server.
> We do not have any file shares, or IIS or any unneeded services running on
> our dedicated SQL Server's -- thus I guess I do not see the merit of using
> anti-virus software on the SQL Server itself when the attach vectors are
> fairly minimized.
> Our SQL Servers are all internal, no DMZ, no external. The only major
> vulnerability would be internal threats (which are minimized by other
> internal controls, i.e. AV at the desktop, etc.).
> Is patch management, properly configured SQL Server security, and a good
> understanding of what services are open on the particular box enough to
> protect against 90-95% of the vulnerabilities that may exist?

Let's say you protect against 95% of all virus vulnerabilities, that still
leaves a 5% exposure. I understand the points you are making, however if one
of my servers were compromised, and I had to make an explanation to
management -- I would not be comfortable in saying that I took most steps in
protecting these servers but not all.
Steve|||> "Aaron Vance" <thisisnttheemailyourlookingfor@.nospam.com> wrote in message

quote:

> news:u$mL3kF4DHA.3576@.TK2MSFTNGP11.phx.gbl...
We run anti-virus software on ALL of our servers regardless of role.
[QUOTE]
> take
on[QUOTE]
using[QUOTE]
>

Let's say you protect against 95% of all virus vulnerabilities, that still
leaves a 5% exposure. I understand the points you are making, however if
one
of my servers were compromised, and I had to make an explanation to
management -- I would not be comfortable in saying that I took most steps
in
protecting these servers but not all.
Steve

订阅：博文 (Atom)

2012年3月19日星期一

Any way to be notified if database grows?

Any way to be notified if database grows?

Any way to be notified if database grows?

2012年2月11日星期六

Anti-Virus on SQL Server? - Merits and Arguments?

Sql ANSI Padding

Blog Archive

About Me