Viewing 15 posts - 211 through 225 (of 1,655 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,...
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...
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...
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...
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...
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...
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...
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
August 11, 2009 at 6:58 am
MarkusB (8/11/2009)
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...
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...
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...
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...
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...
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
July 27, 2009 at 4:57 am
Viewing 15 posts - 211 through 225 (of 1,655 total)