sys.dm_exec_connections, sys.dm_exec_sessions and sys.dm_exec_requests
I was going through the DMVs in SQLServer 2005 to figure out how these views
are related and better understand performance optimization. I have a
question about the same:
I was checking the data returned by sys.dm_exec_connections,
sys.dm_exec_sessions and sys.dm_exec_requests.
Looks like, sys.dm_exec_connections, returns data about the physical
connections such as Client protocol, version, encryption, net packet size
..... etc. Basically these are details that does not change for a connection
till the connection is disconnected and reconnected.
The sys.dm_ex...Installing Exchange Sys Manager on Win2k Pro
I cannot get the Excahnge 2k Sys Manager installed on Win2k Pro. I have
installed the AdminPak.msi. I receive the following messages in the Exchange
regsvr32.exe -s imapadm.dll
failed, returning error code 5 (Access is denied.). ScCreateProcess
Error code 0XC103798A (31114): An internal component has failed.
Error code 0XC103798A (31114): An internal component has failed.
[10:29:04] Processing file 'd:\setup\i386\...sys.dm_exec_query_stats
Is there a way to tell which spid, and in turn from which ip, ran a last
query found in sys.dm_exec_query_stats?
RG (email@example.com) writes:
> Is there a way to tell which spid, and in turn from which ip, ran a last
> query found in sys.dm_exec_query_stats?
No. That spid may have disconnected since it rant the query.
Erland Sommarskog, SQL Server MVP, firstname.lastname@example.org
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Hello, where can I find this function?
I'm looking int system view, but I can't find this function...
Can anyone tell me the right way?
Thanks in advance
Under master database, Functions---SystemFunctions----Table-Valued Functions
"Alciabide" <email@example.com> wrote in message
> Hello, where can I find this function?
> I'm looking int system view, but I can't find this function...
> Can anyone tell me the right way?
> Thanks in advance
...What processor(sys requirements) should my computer have to run the following:
I have developed a series of reports using pivot tables, multiple vlookup functions. Example:
Report 1 has a database of 20000plus records, from which I created a pivot table. In addition, I have 2 columns which return values using a vlookup everytime I refresh the pivot table. These Vlookup formulas read information from another database, but this database if for 2000 records only
My computer spends around 5 minutes calculaing everytime a single change is done (it often crashes)
In addition, my job requires me to have open applications as Outlook, and Oracle(manufacturing system...sys admin privileges
is there a way to restore the original privileges for the sys admin. The
override order pricing was unchecked and now we cannot get it back. (It
just gives us an error message when we check it and save it.)
Ok so about 5 days ago my computer blue screened on me while I was
surfing the internet. Rebooted it and now it blue screens on me every
time. I restart the computer and after putting my password in it show's
my desktop for about 4 seconds and blue screens. Here is what it says.
This problem seems to be caused to file tdidis32.sys. I looked it up and
I guess it�s a Trojan.
Stop: 0x00000050 (0x81000078, 0x00000000, 0xad49c3fb, 0x00000000.)
Tdidis32.sys- address ad49c3f8, base at ad49b000, date stamp 4af69b2e.
I can�t start my system in safe ...STOP: 0x00000050 pci.sys
STOP: 0x00000050 (0xFA3A9BC4,0x00000000,0xF84F3AB9,0x00000000)
pci.sys - Address F84F3AB9 base at F84F1000, datestamp 480252bb
This is the error im getting when computer starts. It wont even go into
safe mode by pressing F8 on start up.
Its a 3.6ghz with 512mb ram running xp. Recently had a virus on it but
was cleared off. So i was told it was cleared off.
JPKaos's Profile: http://forums.techarena.in/members/156350.htm
View this thread: http://forums.techarena.in/windows-x...Replacing USBSTOR.sys
Is it possible to replace USBSTOR.sys?
How can we start developing driver to replace USBSTOR.sys?
What are the responsibilities of USBSTOR.sys that must be fulfilled to be
able to replace it?
> Is it possible to replace USBSTOR.sys?
ImagePath registry value.
> What are the responsibilities of USBSTOR.sys that must be fulfilled to =
> able to replace it?
Conversion of SCSI CDBs to USBSTOR URBs
Enumeration of the child devnode for the storage LUN
Supporting all IOCTLs the storage port driver should
Maxim S. Shatskih
Windows DDK MVP
Can I stop Vista from creating/using this file? I don't use hibernate
Type in search on the Start menu "command" and in the list of options right
click Command Prompt and choose Run as administrator. Type
powercfg -h off
"+Bob+" <firstname.lastname@example.org> wrote in message
> Can I stop Vista from creating/using this file? I don't use hibernate
On Sat, 17 Apr 2010 15:46:44 +1000, <.> wrote:
>Type in search on the Start menu "c...Windows Server 2003 BSOD "Apparantley Caused by Win32k.sys Help!!!
One of my Windows Server 2003 Enterprise Server Running SP2 Will Most
Certainly BSOD at least once a day (Usually Occuring at Night)
I have done scan's of the memory Dumps and they all point to the
win32k.sys file. This is a Virtual Machine BTW running on ESX 3.5.
Here are the Error Codes....
System Failure : Stop Error
0x00000050 (0xbc529e90, 0x00000001, 0xbf8b8006, 0x00000000)
BCCode : 50 BCP1 : bc529e90 BCP2 : 00000001 MCP3 BF8B8006
BCP4 000000 OSVER : 5_2_3790 SP : 2_0 PRODUCT 18_3
I have Search to ends earth and ...sys.dm_db_index_physical_stats
I'm looking for a good, indepth, writeup on sys.dm_db_index_physical_stats.
Have you read BOL?
"Jay" <email@example.com> wrote in message
> I'm looking for a good, indepth, writeup on
Yes, however, it clearly gets much more involved.
"Uri Dimant" <firstname.lastname@example.org> wrote in message
> Have you read BOL?
> "Jay" <email@example.com> wrote in message
I am installing my Brother wireless printer (MFC-495CW) and I encountered the
following "Files Needed" pop up window. "The file 'serscan.sys' on Windows XP
Home Edition CD-ROM is needed'. Type the path where the file is located and
then click OK"
I installed the OS CDROM that Dell gave me and nothing works. I also tried
to find the file itself in the C drive under C:\\Windows\Driver Cache|I386
and still nothing. Does anyone know where I can this file?
"rma2113" <firstname.lastname@example.org> wrote in message
The following tables relating to workflow are huge especially the WFRule log,
these three tables are over 90% of the <organisation_name>_MSCRM database
Is there any way to purge the workflow logs rather than 1000 at a time?
I'm sure other CRM administrators must be having a similar problem!
Isn' there anyone that can help me?
What about you MVP guys?
You could probably write a query to do this yourelf, but you will need to
race the calls exectued when you purge them.
I am a .net programmer, but sometimes get SQL Server DBA tasks as we don't
have a DBA. There is a situation where the database seems to lock up
occasionally. Below is a row from sys.dm_db_index_operational_stats, where
the row_lock_wait_in_ms is very high. Can you please give me some clues as
to what would cause this? Also, can you please give me a straightforward
reference that would help someone like myself who is not a DBA by trade as to
what best practices are to maintain a database? Thanks.
object_id ...messages are automatically purge
I'm using Outlook 2003 SP1
My outlook is configured with IMAP folders.
When I delete a message the message is deleted for good.
Meaning it's not put on the Deleted Items. It's gone
I want to turn off this feature.
How do I do that?
If you need anymore information let me know.
Thanks in advance
Sounds like you have the "Hide Messages Marked for Deletion" view turned on
for that folder.
Outlook's IMAP component does not send messages to Deleted Items when you
delete them. Instead, it marks the for deletion in the original folder. You
Can I increase the database size in Express08 by updating the sys.
database_files table? any place else I would need to update?
Are you asking for the hack that allows you to get around the size
limitation of the free SQL Server version?
"Miss1868" <u57228@uwe> wrote in message news:a196816e83b90@uwe...
> Can I increase the database size in Express08 by updating the sys.
> database_files table? any place else I would need to update?
You can’t go past the rated size, period.
Andrew J. Kelly SQL MVP
On my exchange server I had System manager open. I went to the server today
and had a few error messages come up -
A local error has occured
ID No: 8007203b
Exchange System Manager
When I closed the error windows and closed sys manager I then tried to
re-open it and got this message -
ID No: c0070005
Exchange System manager
I have looked on the microsoft site nad cannot find naything to explain
these error messages. I can now not open sys man and it looks like I'm
going to have to reboot .
...Purge Deleted Messages does not Work!
I'm using Outlook 2002 to connect to an IMAP server,
however recently the Purge Deleted Message is failing to
work. It asks if I'm sure then just doesn't to anything?!
...error with sys.dm_db_index_physical_stats
When I run this on the following database/table (or any table in the "Caser"
database for that matter):
select * from sys.dm_db_index_physical_stats (DB_ID(N'Caser'),
OBJECT_ID(N'dbo.tblJudges'), NULL, NULL, NULL)
I get the error:
Incorrect syntax near '('
But if I run it on a different table in a different database (something in
Adventureworks for example or one of my own other databases) it works
correctly. Owner of the above table is dbo.
I ran PRINT DB_ID(N'Caser') and PRINT OBJECT_ID(N'dbo.tblJudges') and they
Have the sys.dm_db_missing_index_* DMV's proven to be useful?
Yes, I find them very useful. But consider the limitations described by Bart:
...sys menu problem in MDI
I have an MDI with 3 childwnd.
Whenever group of views from chiuldwnd type X is shown the childwnd Y views
and childwnd Z views are hidden via ShowWindow(SW_HIDE) when changing the
activate frame. it works.
But when I press the minimize box on the ChildWnd sys menu, i C all the
views no matter what type are them. I want that when I press the system menu
the other views types will still be hidden and the views of the vurrent type
will be shown as minimize, how di I do it ?
I've some problems with a File named HookCentre.sys because it causes a
blue screen..!!! Can somebody help me??
Christian Jehle <email@example.com> wrote:
>I've some problems with a File named HookCentre.sys because it causes a
>blue screen..!!! Can somebody help me??
G-DATA Anti-Virus Kit?
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:h.pott@get...Delete pagefile.sys
I want to delete my pagefile and can not do
Chanding to no page file and rebooting does not delete the page file
tried everything , when I tried to delete it , it tell some other
program is using it
Tried deleting it in safe mode no good.
There must be a away to delete I can scan for it and it shows where it
But I can not delete it.
The page file is part of the operating system and cannot be deleted.
Errare humanum est
> I want to delete my pagefile and can not do
> Chanding to no page file and rebooting does not delete the...Offline Fulltext Catalog
I have inherited a few SQL servers with a number of databases all exhibiting
the same problem. They all had a missing Fulltext Catalog file which was
causing errors on backup.
I sorted most of them by dropping the the full text catalog using DROP
However 6 of the databases report no fulltext catalogs exists even though
sys.database_files has a entry for a fulltext catalog called
sysft_DatabaseName on drive S:. Neither DROP FULLTEXT CATALOG or ALTER
DATABASE REMOVE FILE work.
5 of these I managed to fix by creating and then deleting a new fulltext...