Home » Script (Page 4)
Category Archives: Script
DMV-4 : Find top most expensive cached queries ?……..sys.dm_exec_query_stats
sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx Returns aggregate performance statistics for cached query plans. The view contains one row per query statement within the cached plan, and the lifetime of the rows are tied to the plan itself. When a plan is removed from the cache, the corresponding rows … Continue reading
DMV-3 : What is currently going on ?……..sys.dm_exec_requests
sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx Returns information about each request that is executing within SQL Server. sys.dm_exec_requests DMV is used to get details of currently running sessions. This DMV help us is getting details like used database, transaction isolation level, open transaction count, status, blocked session, percentage of task … Continue reading
DMV-2 : Explore the secrets of session…… sys.dm_exec_sessions
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view that shows information about all active user connections and internal tasks. This information includes client version, client program name, client login time, login user, current session setting, and more. sys.dm_exec_sessions is extremely useful DMV when … Continue reading
Microsoft SQL Server License Helpline
Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based on versions or license based on environment (physical or virtual). Although, Microsoft release license guidelines for each & every SQL server version. But there are more complex scenarios for licensing then we think. Best … Continue reading
How to move file through FTP by CMD ?
CMD code to upload file direct into root of FTP site of server @ echo off REM ******** this batch file is to upload file echo user username> ftpcmd.dat echo password>> ftpcmd.dat echo bin>> ftpcmd.dat echo lcd D:\Filelocation>>ftpcmd.dat echo put filename.csv>> ftpcmd.dat echo quit>> ftpcmd.dat ftp -n -s:ftpcmd.dat 172.xx.xx.xxx del ftpcmd.dat CMD code to upload … Continue reading