Viewing 15 posts - 211 through 225 (of 1,654 total)
First, I'd like to say that the query only gives you information about the currently connected users. I thought you wanted to know the last access time for any user,...
[font="Verdana"]Markus Bohse[/font]
August 28, 2009 at 6:47 am
ananda.murugesan (8/28/2009)
I need script to get the
last accessed date for each database user
(database level), or the last access
of each login (SQL Server level).
Is there a way to...
[font="Verdana"]Markus Bohse[/font]
August 28, 2009 at 4:36 am
I agree Powershell would probably work, but I haven't tried it yet.
An alternative is SQLH2 Perfcollector. I have used it in the past to collect performance counter data and...
[font="Verdana"]Markus Bohse[/font]
August 24, 2009 at 7:20 am
This is your problem: SQL Server does not exist or access denied.
When you run the package manually it runs under your security context.
When you schedule it it will run...
[font="Verdana"]Markus Bohse[/font]
August 21, 2009 at 4:22 am
TRACEY (8/15/2009)
Mark the record.value('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int') AS the path is this a specific path somewhere. Did you set this up in master or just any "DBSYSTEMDB"Cheers
Tracey, if...
[font="Verdana"]Markus Bohse[/font]
August 16, 2009 at 5:49 am
rew (8/13/2009)
Hi MarkusWhat executable (e.g., sqlservr.exe) does your script monitor for CPU usage?
thanks
Yes, the script uses the DMV sys.dm_os_ring_buffers, but it's basically the same as if you monitor the...
[font="Verdana"]Markus Bohse[/font]
August 14, 2009 at 4:02 am
The query you mention helps you to find longrunning queries which use a lot of CPU time, but it won't tell you the overall % CPU usage at that specific...
[font="Verdana"]Markus Bohse[/font]
August 13, 2009 at 3:00 am
That's exactly what I remembered.
But if you use TSQL scripts it should still work. This article should help you with it.
http://www.databasejournal.com/features/mssql/article.php/3832106/Database-Mirroring-Using-T-SQL.htm
[font="Verdana"]Markus Bohse[/font]
August 11, 2009 at 6:58 am
MarkusB (8/11/2009)
[font="Verdana"]Markus Bohse[/font]
August 11, 2009 at 3:53 am
I'm not an expert on this issue but I'm pretty sure that as long as the disk block which had the data stored are not overwritten with some other data...
[font="Verdana"]Markus Bohse[/font]
August 11, 2009 at 3:52 am
Yes you can use mirroring without a domain. But you might have to set it up using TSQL.
I remember that once you installed SP2, the wizard in SSMS won't accept...
[font="Verdana"]Markus Bohse[/font]
August 11, 2009 at 3:43 am
bpowers (8/10/2009)
How can I modify your script to group or order by TbName?
I'm not sure what you mean. My script has no column called tbname.
If you mean tablename, you...
[font="Verdana"]Markus Bohse[/font]
August 11, 2009 at 12:44 am
A login exists on the server-level and gives you access to the SQL Server but not necessary to a database.
A user exists within a database and has access to that...
[font="Verdana"]Markus Bohse[/font]
July 29, 2009 at 4:47 am
sukhoi971 (7/27/2009)
sql server 2008 express allows 4gb space enough for meis it per DB or for the entire sql server ?
It's per database.
how will be able to use sql server...
[font="Verdana"]Markus Bohse[/font]
July 29, 2009 at 2:21 am
I maybe a little bit late with this reaction, but you might find this link rather useful:
http://blogs.msdn.com/bimusings/archive/2005/07/29/445080.aspx
[font="Verdana"]Markus Bohse[/font]
July 27, 2009 at 4:57 am
Viewing 15 posts - 211 through 225 (of 1,654 total)