![]() If the VM has 1 vCPU this Query takes about 15-17 seconds, but if we add processors (2,4,8 doesn't matter) it takes about 27-29 second, no other changes done. When testing this on the SQL-server we are running a normal Select query selecting 1 000 000 rows from a table. We've switched to using Hyper-V as our primary virtualization engine for hosting VM's about 3-4 years ago (switching from VMWare) and haven't had any noticable issues since then.īut now a hosted customer noticed performance issues when running SQL-server on the virtualized Machines, I don't think this is a "new" problem but no one ever "complained" about performance so therefore we haven't done any real testingĪnd measuring of this particular problem before. See Books Online for details of when this behavior is expected and what workarounds exist. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. The database could not be exclusively locked to perform the operation.Ĭheck statement aborted. Attempting to get exclusive access to run checks offline. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. The database snapshot for online checks could not be created. Operating system error 80: "80(The file exists.)". Unable to open the physical file "/xxxx/xxxxxx.mdf_MSSQL_DBCC22". I cannot find a solution for this, so any help will be much appreciated!Įrror message:-Ī database snapshot cannot be created because it failed to start. While running the DBCC Check db against the failing database, it seems that the DBCC snapshot file generated, does not get cleaned upĬorrectly which I believe to be the cause of the error.() The file can be see from the Azure storage interface. The one database that fails has it's data files in Azure premium storage (https:\.\xxxx), the rest is onĬlassic storage, as is the Azure VM server itself. ĭBCC CHECKDB are runing just fine on all databases on the server except one, TblCPlogoninfo.Username = tblAssets.I have an issue running DBCC CHECKDB on one of our SQL Server Azure wm's. TblCPlogoninfo.Username = tblAssets.Username Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID And If you would like to have precise logon information, you need to set up logon scripts on your computers which initiate a scan with LsPush after a user logged on. ![]() If another user logged on and off while the computer wasn't scanned, Lansweeper won't get to know this. Please note: Lansweeper adds an entry to tblCPlogoninfo after scanning a computer while a user was logged on. You only need the logon date from tblCPlogoninfo. The last logged on user is always stored in tblAssets.Username. Your report list all of these which is not required in your case. TblUsers contains all local user accounts which were scanned on the computer. Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetIDĪny help and advice is appreciated as I am pretty much a SQL beginner. Right Join tblUsers On tblAssets.AssetID = tblUsers.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Max(tblCPlogoninfo.logontime) As LastLogon I am sure it is something obvious I am doing wrong. This morning I just cant seem to figure out why each user name is listed several times for each device. The report I have tried to put to together does everything I need except each login is multiplied 4 or 5 times, all with the same time and date stamp. I am needing a report that, among other things, lists the last user that logged into the computer and the username.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |