Thanks
-Jamie MacLennan
SQL Server Data Mining
SQL Server Analysis Servicessql
Showing posts with label obtain. Show all posts
Showing posts with label obtain. Show all posts
Wednesday, March 28, 2012
Latest information acquisition place
Where can I obtain the latest information on a Data Mining function?Books on line has a lot of information. You can also find a lot of information at www.sqlserverdatamining.com. Later this month (9/26) the book "Data Mining with SQL Server 2005" by Zhaohui Tang and me will be released as well.
Latest Hotfix
Hello all,
Could someone tell me what the latest, supported hotfix is for post-SQL
Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
now on 2 different servers I've seen 2 strange errors that have caused us to
reboot the servers. Basically the text of the error message is:
The Scheduler 0 appears to be hung. or
The Scheduler 1 appears to be hung.
Thanks,
Jason
There have been quite a few since 818. Use this as a guide.
http://www.aspfaq.com/show.asp?id=2160
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jason
|||Thanks oj! That's the info I was looking for!
Jason
"oj" wrote:
> There have been quite a few since 818. Use this as a guide.
> http://www.aspfaq.com/show.asp?id=2160
>
> "Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
> news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> to
>
>
|||also bear in mind that there has been extra instrumentation added to post
sp3 builds that mean you are likely to get more output (Even though the
problem was happening on sp3). Do a search on the kb on "appears to be hung"
there is an article that describes that error.
Andy.
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jason
Could someone tell me what the latest, supported hotfix is for post-SQL
Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
now on 2 different servers I've seen 2 strange errors that have caused us to
reboot the servers. Basically the text of the error message is:
The Scheduler 0 appears to be hung. or
The Scheduler 1 appears to be hung.
Thanks,
Jason
There have been quite a few since 818. Use this as a guide.
http://www.aspfaq.com/show.asp?id=2160
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jason
|||Thanks oj! That's the info I was looking for!
Jason
"oj" wrote:
> There have been quite a few since 818. Use this as a guide.
> http://www.aspfaq.com/show.asp?id=2160
>
> "Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
> news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> to
>
>
|||also bear in mind that there has been extra instrumentation added to post
sp3 builds that mean you are likely to get more output (Even though the
problem was happening on sp3). Do a search on the kb on "appears to be hung"
there is an article that describes that error.
Andy.
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jason
Latest Hotfix
Hello all,
Could someone tell me what the latest, supported hotfix is for post-SQL
Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
now on 2 different servers I've seen 2 strange errors that have caused us to
reboot the servers. Basically the text of the error message is:
The Scheduler 0 appears to be hung. or
The Scheduler 1 appears to be hung.
Thanks,
JasonThere have been quite a few since 818. Use this as a guide.
http://www.aspfaq.com/show.asp?id=2160
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jason|||Thanks oj! That's the info I was looking for!
Jason
"oj" wrote:
> There have been quite a few since 818. Use this as a guide.
> http://www.aspfaq.com/show.asp?id=2160
>
> "Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
> news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> to
>
>|||also bear in mind that there has been extra instrumentation added to post
sp3 builds that mean you are likely to get more output (Even though the
problem was happening on sp3). Do a search on the kb on "appears to be hung"
there is an article that describes that error.
Andy.
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jasonsql
Could someone tell me what the latest, supported hotfix is for post-SQL
Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
now on 2 different servers I've seen 2 strange errors that have caused us to
reboot the servers. Basically the text of the error message is:
The Scheduler 0 appears to be hung. or
The Scheduler 1 appears to be hung.
Thanks,
JasonThere have been quite a few since 818. Use this as a guide.
http://www.aspfaq.com/show.asp?id=2160
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jason|||Thanks oj! That's the info I was looking for!
Jason
"oj" wrote:
> There have been quite a few since 818. Use this as a guide.
> http://www.aspfaq.com/show.asp?id=2160
>
> "Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
> news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> to
>
>|||also bear in mind that there has been extra instrumentation added to post
sp3 builds that mean you are likely to get more output (Even though the
problem was happening on sp3). Do a search on the kb on "appears to be hung"
there is an article that describes that error.
Andy.
"Jason Delaune" <JasonDelaune@.discussions.microsoft.com> wrote in message
news:34E2127E-94C3-439D-AA1D-CAAA2FD5D573@.microsoft.com...
> Hello all,
> Could someone tell me what the latest, supported hotfix is for post-SQL
> Server 2000 SP 3a and how I can obtain it? Currently we're at 8.00.818 and
> now on 2 different servers I've seen 2 strange errors that have caused us
to
> reboot the servers. Basically the text of the error message is:
> The Scheduler 0 appears to be hung. or
> The Scheduler 1 appears to be hung.
> Thanks,
> Jasonsql
Friday, March 23, 2012
last tsql command
hi, how can i obtain the info of the last tsql command executed?, in the table sysprocess i only have the number of spid
thanks so much...have you tried double-clicking the spid in Enterprise Manager->Management->Current Activity->Process Info?
...might give you what you're looking for...|||hi, yes, but sql save it in someplace? i need to extract it to a table|||Not that I'm aware of, you'd have to run profiler to capture the sql (even then I am not sure you can save it to a table...)|||(even then I am not sure you can save it to a table...)Yes you can though MS recommend you write to a trace file and insert this into a table when you want to analyse. More efficient to write to a file at trace time basically.
HTH|||@.Mvrg76: Why have you opened a new thread?
See http://www.dbforums.com/showthread.php?t=1613810sql
thanks so much...have you tried double-clicking the spid in Enterprise Manager->Management->Current Activity->Process Info?
...might give you what you're looking for...|||hi, yes, but sql save it in someplace? i need to extract it to a table|||Not that I'm aware of, you'd have to run profiler to capture the sql (even then I am not sure you can save it to a table...)|||(even then I am not sure you can save it to a table...)Yes you can though MS recommend you write to a trace file and insert this into a table when you want to analyse. More efficient to write to a file at trace time basically.
HTH|||@.Mvrg76: Why have you opened a new thread?
See http://www.dbforums.com/showthread.php?t=1613810sql
Monday, March 12, 2012
Last connect/update/modify date
Hi all,
Could anyone give me any information on how to obtain information from my SQL Server db's that will indicate the date of last connection/update/user activity?
Many thanks,
MeganThere are SP's and other ways to list some info about what's happening right now in the database, but I can't find anything about what happened earlier.
Maybe a log explorer tool could help with some parts.|||Thanks for the response :)|||Under Management -> Current Activity, will give you some information. You can also enable successful/failed login auditing - this is probably what you will need to enable as well as using sql profiler.|||The following is a good article:
article (http://www.ddart.net/mssql/sql2000/html/adminsql/ad_security_2ard.htm)|||Is the contents of that web site the same as in Books On-Line?|||> You can also enable successful/failed login auditing
Where do I do this?|||SQL profiler is the best tool for this - but you can also use auditing under the sql server properties -> security -> "Audit Level". Under SQL Profiler - Create a trace -> Events - you will see several auditing choices.|||Thanks to all who responded!
I ended up creating a custom trace template in Profiler and create my trace files based on it.
It's not awe-inspiring, but it's the only solution I've come across so far without looking at purchasing some kind of 3rd party log-miner/auditing software.
Could anyone give me any information on how to obtain information from my SQL Server db's that will indicate the date of last connection/update/user activity?
Many thanks,
MeganThere are SP's and other ways to list some info about what's happening right now in the database, but I can't find anything about what happened earlier.
Maybe a log explorer tool could help with some parts.|||Thanks for the response :)|||Under Management -> Current Activity, will give you some information. You can also enable successful/failed login auditing - this is probably what you will need to enable as well as using sql profiler.|||The following is a good article:
article (http://www.ddart.net/mssql/sql2000/html/adminsql/ad_security_2ard.htm)|||Is the contents of that web site the same as in Books On-Line?|||> You can also enable successful/failed login auditing
Where do I do this?|||SQL profiler is the best tool for this - but you can also use auditing under the sql server properties -> security -> "Audit Level". Under SQL Profiler - Create a trace -> Events - you will see several auditing choices.|||Thanks to all who responded!
I ended up creating a custom trace template in Profiler and create my trace files based on it.
It's not awe-inspiring, but it's the only solution I've come across so far without looking at purchasing some kind of 3rd party log-miner/auditing software.
Friday, March 9, 2012
Largest SQL Server 2000 Enterprise Ed. Databases
I like to obtain information on several of the largest
SQL Server 2000 Enterprise Edition databases? With the
hardware specification and disk space (SAN, LUN, etc.)
they are using.
Also would be helpful the average number of transactions
per minute the server is handling.
If the application used a third party utility to enhance
application scheduling?
I would like to obtain this information for trading floor
application that I'm am working on.
Thanks,
MikeHi,
Have a look into the below link for details.
http://www.microsoft.com/sql/evalua.../wintercorp.asp
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx
.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike|||Mike,
'Scalability and Very Large Database (VLDB) Resources'
http://www.microsoft.com/sql/techin...scalability.asp
'Transaction Processing Performance Council'
http://www.tpc.org/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx
.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
SQL Server 2000 Enterprise Edition databases? With the
hardware specification and disk space (SAN, LUN, etc.)
they are using.
Also would be helpful the average number of transactions
per minute the server is handling.
If the application used a third party utility to enhance
application scheduling?
I would like to obtain this information for trading floor
application that I'm am working on.
Thanks,
MikeHi,
Have a look into the below link for details.
http://www.microsoft.com/sql/evalua.../wintercorp.asp
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx
.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike|||Mike,
'Scalability and Very Large Database (VLDB) Resources'
http://www.microsoft.com/sql/techin...scalability.asp
'Transaction Processing Performance Council'
http://www.tpc.org/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx
.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
Largest SQL Server 2000 Enterprise Ed. Databases
I like to obtain information on several of the largest
SQL Server 2000 Enterprise Edition databases? With the
hardware specification and disk space (SAN, LUN, etc.)
they are using.
Also would be helpful the average number of transactions
per minute the server is handling.
If the application used a third party utility to enhance
application scheduling?
I would like to obtain this information for trading floor
application that I'm am working on.
Thanks,
Mike
Hi,
Have a look into the below link for details.
http://www.microsoft.com/sql/evaluat...wintercorp.asp
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
|||Mike,
'Scalability and Very Large Database (VLDB) Resources'
http://www.microsoft.com/sql/techinf...calability.asp
'Transaction Processing Performance Council'
http://www.tpc.org/
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
SQL Server 2000 Enterprise Edition databases? With the
hardware specification and disk space (SAN, LUN, etc.)
they are using.
Also would be helpful the average number of transactions
per minute the server is handling.
If the application used a third party utility to enhance
application scheduling?
I would like to obtain this information for trading floor
application that I'm am working on.
Thanks,
Mike
Hi,
Have a look into the below link for details.
http://www.microsoft.com/sql/evaluat...wintercorp.asp
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
|||Mike,
'Scalability and Very Large Database (VLDB) Resources'
http://www.microsoft.com/sql/techinf...calability.asp
'Transaction Processing Performance Council'
http://www.tpc.org/
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
Largest SQL Server 2000 Enterprise Ed. Databases
I like to obtain information on several of the largest
SQL Server 2000 Enterprise Edition databases? With the
hardware specification and disk space (SAN, LUN, etc.)
they are using.
Also would be helpful the average number of transactions
per minute the server is handling.
If the application used a third party utility to enhance
application scheduling?
I would like to obtain this information for trading floor
application that I'm am working on.
Thanks,
MikeHi,
Have a look into the below link for details.
http://www.microsoft.com/sql/evaluation/compare/wintercorp.asp
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike|||Mike,
'Scalability and Very Large Database (VLDB) Resources'
http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp
'Transaction Processing Performance Council'
http://www.tpc.org/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
SQL Server 2000 Enterprise Edition databases? With the
hardware specification and disk space (SAN, LUN, etc.)
they are using.
Also would be helpful the average number of transactions
per minute the server is handling.
If the application used a third party utility to enhance
application scheduling?
I would like to obtain this information for trading floor
application that I'm am working on.
Thanks,
MikeHi,
Have a look into the below link for details.
http://www.microsoft.com/sql/evaluation/compare/wintercorp.asp
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike|||Mike,
'Scalability and Very Large Database (VLDB) Resources'
http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp
'Transaction Processing Performance Council'
http://www.tpc.org/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:15a7501c446c5$e8df33a0$a101280a@.phx.gbl...
> I like to obtain information on several of the largest
> SQL Server 2000 Enterprise Edition databases? With the
> hardware specification and disk space (SAN, LUN, etc.)
> they are using.
> Also would be helpful the average number of transactions
> per minute the server is handling.
> If the application used a third party utility to enhance
> application scheduling?
> I would like to obtain this information for trading floor
> application that I'm am working on.
> Thanks,
> Mike
Subscribe to:
Posts (Atom)