Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-10-12 : 19:08:55
|
| Perhaps very basic but Can Anyone suggest me how to find the Server to be Physical or Virtual in Nature, like from the OS as well as SQL Level.Thanks In Advance. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-10-13 : 07:34:08
|
| This is in fact a hard question to answer! At least to my knowledge...I've often wondered myself and the only answer I've been able to come up with is to look through the services on the server. If I find any VMWare services (especially "VMware Tools Service") I usually conclude with the server being virtual. You can also look in task manager under running processes...in the description column there has a tendency to be something regarding VMWare. I have no idea how to do it programmatically though...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-10-13 : 19:27:53
|
| Thanks Webfred,and Lumbago.(rightly said that this has gotlittle information from the task Manager panel) Webfred - but it is not acepting with the table. |
|
|
|
|
|
|
Physical Or Virtual