Activity overview
Latest activity by AdamMetcalfe
                    
                      
                        yes i did check your link out, the network resiliance is something that is pretty important in our environment, this is probably the main big ticket item for keeping it at the moment would be. we would still use it for log shipping i think as well. / comments
                        
                        
                        
                      
                      
                      
                
                  yes i did check your link out, the network resiliance is something that is pretty important in our environment, this is probably the main big ticket item for keeping it at the moment would be. we w...
                      
                    
                  
                    
                      
                        Petey  
Unfortunately I thought i had it right, thanks for confirming.  
I will be trialling next week with my own DB, but i need to write a business case for extra disk required when going with TDE now. What are the other advantages of SQL Backup when encryption is used? Im not a heavy user of SQL Backup (mainly used for log shipping). But if we cannot compress. I think we need to look at dropping the product. I am not saying the product is bad, but maybe our use for it diminishes without this advantage?  
I was secretely hoping someone was going to say yes it will compress, Nothing like having your encrypted cake and compressing it too. [image]  / comments
                        
                        
                        
                      
                      
                      
                
                  Petey
Unfortunately I thought i had it right, thanks for confirming.
I will be trialling next week with my own DB, but i need to write a business case for extra disk required when going with TDE no...
                      
                    
                  
                    
                      
                        SQL2008 TDE and SQLBackup Compression
                        
                        
                        
                        
                      
                      
                      
                
                  A really simple question, but i think i already know the answer.
How well does SQLBackups compression work with a TDE enabled database. Some real world examples would be great.
My current understan...
                      
                    
                  
                    
                      
                        SqlMonitor runs MUCH faster in google chrome than in IE8
                        
                        
                        
                        
                      
                      
                      
                
                  All,
I had been having concerns about the speed and refresh rate of the sqlmonitor tool , and trying to use it effectively to monitor my servers.
On a whim i thought i would try it in google chrome...
                      
                    
                  
                    
                      
                        Hi Chris,  
The install is essentially straight out of the box and as such configuration of the alerts etc has not changed, from the defaults. 
The servers were not under any extra load when the trace was run. As such no extra alerts were being raised when trace was on.  
I note today that the memory being used by the service is now at 462mb.  
And CPU is al reduced on the server.  
I hope this helps, if i can provide extra information (logs etc) please let me know. / comments
                        
                        
                        
                      
                      
                      
                
                  Hi Chris,
The install is essentially straight out of the box and as such configuration of the alerts etc has not changed, from the defaults.
The servers were not under any extra load when the trace...
                      
                    
                  
                    
                      
                        responsive improves when tracing is switched off on the servers. / comments
                        
                        
                        
                      
                      
                      
                
                  responsive improves when tracing is switched off on the servers.
                      
                    
                  
                    
                      
                        Specifically this process is taking up a lot of memory (about 1.7gb)  
RedGate.Response.Engine.Alerting.Base.Service / comments
                        
                        
                        
                      
                      
                      
                
                  Specifically this process is taking up a lot of memory (about 1.7gb)
RedGate.Response.Engine.Alerting.Base.Service
                      
                    
                  
                    
                      
                        Slow Response on WebServer
                        
                        
                        
                        
                      
                      
                      
                
              Hi support,
I am getting slow response when browsing to the site for SQL Monitor. Sometimes it does not even respond.
IIS Server + Base Monitor on an IIS7 Windows Web Server 2008 R2
Database is on ...
                      
                    
                  