Is it possible to tell on sql server what queries are run
against it?
If a program is built within a company and it links to a
SQL server that I manage. Can I tell what is run against
it?
Thanks,
JeffSure. Use Profiler!
--
Tibor Karaszi
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:0c9f01c3a2e9$f8cab620$a601280a@.phx.gbl...
> Is it possible to tell on sql server what queries are run
> against it?
> If a program is built within a company and it links to a
> SQL server that I manage. Can I tell what is run against
> it?
> Thanks,
> Jeff|||Thanks. I forgot about all those other programs in the
Start Menu.
Jeff
>--Original Message--
>Sure. Use Profiler!
>--
>Tibor Karaszi
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0c9f01c3a2e9$f8cab620$a601280a@.phx.gbl...
>> Is it possible to tell on sql server what queries are
run
>> against it?
>> If a program is built within a company and it links to
a
>> SQL server that I manage. Can I tell what is run
against
>> it?
>> Thanks,
>> Jeff
>
>.
>sql
Showing posts with label built. Show all posts
Showing posts with label built. Show all posts
Wednesday, March 21, 2012
Tuesday, March 20, 2012
Queries between servers
This has happened multiple times but I will only mention one story to lay the
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box and
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
ThanksThere is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box and
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
ThanksThere is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks
Queries between servers
This has happened multiple times but I will only mention one story to lay th
e
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box an
d
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
ThanksThere is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks
e
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box an
d
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
ThanksThere is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks
Queries between servers
This has happened multiple times but I will only mention one story to lay the
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box and
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
Thanks
There is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box and
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
Thanks
There is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks
Subscribe to:
Posts (Atom)